Got it. Use to_char not to_date :) Tim
-----Original Message----- From: Timothy Heald Sent: Friday, October 25, 2002 10:05 AM To: CF-Talk Subject: RE: Verity Ordering Take 2. I am trying to do that with Oracle's to_date function, but it keeps saying that a char was found where a numeric value was expected. I am trying to sort that out now. Tim -----Original Message----- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: Friday, October 25, 2002 9:50 AM To: CF-Talk Subject: RE: Verity Ordering Take 2. Quoting Timothy Heald <[EMAIL PROTECTED]>: > > You are the man, I didn't even think about that. Ok, so is there a > function (like convert() in SQL Server) that would let you change the > date format for the whole column at once? Don't think so. But where does Verity get that date from, and can't you change it the moment it gets read from there? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
