I believe it is Now() Actually waht I do for all my CF apps is set a var to Now() and insert that instead of being dependent on the database default that way my code is portable across other RDBMS
Oracle = sysdate Access = now() mysql= now() sql = getdate() ----- Original Message ----- From: "Parker, Kevin" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Wednesday, June 22, 2005 10:14 PM Subject: getDate() > > I usually use SQL Server to do stuff and as a matter of practice I > create a DateTimeStamp field in each table and give it a default of > getDate() so that each row added to each table records the date and time > it was added. > > I have to do a little thing with mySQL but for the life of me can not > find out/figure out how to replicate this in mySQL. > > Any tips greatly appreciated!!!! > > ++++++++++ > Kevin Parker > Web Services Consultant > WorkCover Corporation > > p: 08 8233 2548 > m: 0418 806 166 > e: [EMAIL PROTECTED] > w: www.workcover.com > > ++++++++++ > > ************************************************************************ > This e-mail is intended for the use of the addressee only. It may > contain information that is protected by legislated confidentiality > and/or is legally privileged. If you are not the intended recipient you > are prohibited from disseminating, distributing or copying this e-mail. > > Any opinion expressed in this e-mail may not necessarily be that of the > WorkCover Corporation of South Australia. Although precautions have > been taken, the sender cannot warrant that this e-mail or any files > transmitted with it are free of viruses or any other defect. > > If you have received this e-mail in error, please notify the sender > immediately by return e-mail and destroy the original e-mail and any > copies. > ************************************************************************ > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
