Re: Datetime Default Value - I want to know too!

2004-04-18 Thread Stormblade
Changing the SQL works fine as long as: a) You have access to the application source and/or the SQL source b) There is only one application and it runs on the same machine as the database. If you change your SQL what happens if you have several applications all in different timezones that use the

Re: Datetime Default Value - I want to know too!

2004-04-18 Thread Adam
This is a great question! I also work on SQL Server (2k) databases as well as Access and MySQL. I run into the same problem. So far, I've just changed the SQL in my applications, but I also would like to know if a default can be set. Regards, Adam On Apr 18, 2004, at 12:01 AM, Stormblade wrote: