Its benificial for code portablitly, but on the other side of things, mysql doesnt have anything built in to do the default date in your field.
So if mysql is a target platform its the only path :) simeon On 6/22/05, Parker, Kevin <[EMAIL PROTECTED]> wrote: > Thanks Eric - I can see how that approach would be beneficial. Thanks > for the tip. > > > > ++++++++++ > Kevin Parker > Web Services Consultant > WorkCover Corporation > > p: 08 8233 2548 > m: 0418 806 166 > e: [EMAIL PROTECTED] > w: www.workcover.com > > ++++++++++ > > -----Original Message----- > From: eric.creese [mailto:[EMAIL PROTECTED] > Sent: Thursday, 23 June 2005 12:59 PM > To: CF-Talk > Subject: Re: getDate() > > 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" <[email protected]> > 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. > > > ************************************************************************ > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210318 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
