there's createdate(), there's <cfqueryparam cfsqltype="cf_sql_date" And if you want to do it in Oracle there's the to_date(string) function.
On Fri, Aug 19, 2011 at 10:04 AM, Mo Lay <[email protected]> wrote: > > 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:5483 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
