getting back to the database solution...try now(); i think that works in mysql, too.
~ dina ----- Original Message ----- From: "Bosky, Dave" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 03, 2002 1:44 PM Subject: RE: datetime formatting > I'm using mySQL with a datetime field. > > Thanks, > Dave Bosky > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 03, 2002 2:39 PM > To: CF-Talk > Subject: RE: datetime formatting > > forget ASP! do it right from the database with a default on the column. in > access use now() in the default field and in MSSQL, use getdate(). > > Anthony Petruzzi > Webmaster > 954-321-4703 > [EMAIL PROTECTED] > http://www.sheriff.org > > > -----Original Message----- > From: Bosky, Dave [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 03, 2002 2:33 PM > To: CF-Talk > Subject: datetime formatting > > > I need to insert the current date and time into a table whenever a record is > created. > How would I format the current date and time in the following format using > ASP? > YYYY-MM-DD HH:MM:SS > I'm not sure of the proper function in ASP to accomplish this task. > > Thanks, > Dave > > > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
