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 Get the mailserver that powers this list at http://www.coolfusion.com
