>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.