Yeh cus ramdomly the code returns 11/01/2004 at one instance and 01/11/2004 on the other.
And cfqueryparam isnt working either <cfqueryparam value="#dateSchedule#" cfsqltype="cf_sql_timestamp"> Although it works fine when used with a Now() function. Warm Regards, Sameer S. Kekade. QUATRO FOUR RETAIL "The right connections for your business" Tel. direct +61 2 9370 2775 Tel. direct +61 2 9370 1062 Fax direct +61 2 9370 1200 Mobile 0409 156 038, 0411 566 650 [EMAIL PROTECTED] www.quatro.com.au -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Monday, 1 November 2004 11:33 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Oracle Date Problem Yes - Use CFQUERYPARAM, and a real Date object, and you should be fine. Works fine with Oracle. It seems somewhere there is some confusion b/w the American date, and the Oz date format. Mark On Mon, 01 Nov 2004 11:12:09 +1100, Sameer Kekade <[EMAIL PROTECTED]> wrote: > Hey all, > > I am using an update statement in oracle to update a date field, and > for some reason the date/timestamp stored is "11/01/2004 11:01:27" > instead of "01/11/2004 11:01:27" > > <cfset datetime = DateFormat(dateSchedule, "dd-mm-yyyy") & " " & > TimeFormat(delay_time, "HH:mm:ss")> > > <CFQUERY DATASOURCE="#application.config.DSN#" DBTYPE="ODBC"> > UPDATE REMINDER > SET REMINDER_TIME = to_date('#datetime#','dd-mm-yyyy > HH24:mi:ss') > WHERE STATUS = 'SCHEDULED' > </CFQUERY> > > Does anyone know the best way to tackle this? > > Thanks in advance. > > Warm Regards, > Sameer S. Kekade. > QUATRO FOUR RETAIL > "The right connections for your business" > Tel. direct +61 2 9370 2775 > Tel. direct +61 2 9370 1062 > Fax direct +61 2 9370 1200 > Mobile 0409 156 038, 0411 566 650 > [EMAIL PROTECTED] > www.quatro.com.au > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To > unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
