>>Just code it into your SQL statement that you're sending to the server?
>
>I'm using MM.NET data binding which uses CommandBuilder deep inside the framework. If this is my only solution, I'll just use trigger or send the datetime in from the client.
Ah yes, that is always a problem. <g>
Another alternative would be to actually return the datetime from the server and write it that way. IOW, call a stored proc to return the value and then add it into your SQL.
Question begs though - why would you worry about the time being different?