Just a note Dave, VBScript only lets you use US English date format (ie mm/dd/yyyy) even if your locale settings are different. I also believe you need ## signs around the date.
Thanks, Tony -----Original Message----- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk 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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
