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 same database? With SQLServer this isn't a problem. Currently with MySQL it is. Although I hear that verion 5 will support stored procedures. Perhaps that will be a workaround for that situation, although it would be much nicer IMO to simply allow us to specify a function/macro for a default value ala SQLServer. On Sun, 18 Apr 2004 11:37:39 -0400, Adam wrote: > 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 -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]