That's an ODBC Date. Just use dateFormat() to make it look however you want.
> -----Original Message----- > From: Richard White [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 25, 2006 11: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:258020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4