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/
