It sucks, but that's the way CF returns dates, regardless of their formatting in the DB.
To return it usable for you, just use CF's DateFormat function: DateFormat(dbDateField,"yyyy-mm-dd") gives you 2006-10-25 DateFormat(dbDateField,"mmm dd, yyyy") gives you October 25, 2006 <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 25, 2006 10:48 AM To: CF-Talk Subject: cf date conversion hi, i have a field saved in mysql database as a Date type oddly when i run a cfquery to get it out of the database it comes back with the following: {ts '2001-01-01 00:00:00'} i am assuming ts means timestamp but this seems odd as it is saved as a date type and if i run the query in the mysql database it just returns 2001-01-01. Am i doing something wrong, or is there a function in cf to convert the above into just the date value that mysql outputs thanks for any help ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
