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