Barney, thanks! I had something similar. Leigh, that is what I was looking for. Works perfectly. Thanks to you as well.
Che -----Original Message----- From: Leigh [mailto:[email protected]] Sent: Tuesday, April 27, 2010 11:44 AM To: cf-talk Subject: RE: Not so simple date format question... Yes, that is one way to do it. If you think you will be doing it frequently, you could create a "view" (containing the convert) and call the view in your CF code: SELECT convert(datetime, YourVarcharCol, 112) AS ConvertedToDateTime .... http://msdn.microsoft.com/en-us/library/ms187928.aspx ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
