I've had success using to_date(field, 'mm/dd/yyyy')
Gene Dew Information Technology Specialist II - Web Developer Purchasing Department 2750 Venture Drive Norman, Oklahoma 73019 Tel: (405) 325-6703 Email: [email protected] -----Original Message----- From: Mo Lay [mailto:[email protected]] Sent: Friday, August 19, 2011 10:05 AM To: cf-newbie Subject: convert string to date format Hi folks, i am capturing a "mmm-yy" as a date from java variable to coldfusion field in order to pass it to Oracle DB. When trying to insert it , i am getting error from Oracle ORA-01843: not a valid month. i know what that means as my destination field is date type. i am using DateFormat (field,"mm/dd/yyyy") to mask it as Oracle wants but it seems still being ignored ... Is there another way in CF to convert string to Date ? thanks guys ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5482 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
