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/
