Scott,
The date format is Oracle is very picky. Its worth having an
Oracle sql referrence book.
If you just want the current date
"update MyTable
set API_UPDATE = 'Sysdate'"
This will update the date field to the current oracle db date.
If you want to manually update the date with CF
you have to use the format
"12-Jun-2000"
The month should be abbreviated to 3 chars
Thanks
Joe
----- Original Message -----
From: "Scott Mulholland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 13, 2000 10:31 AM
Subject: Oracle Time...again
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C00533.33F6C520
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> I am using the following statement to insert a date/time string into an
> Oracle table (date field type):
>
> update MyTable
> set API_UPDATE = TO_DATE('#DateFormat(Now(),"mm/dd/yy")#
> #TimeFormat(Now(),"hh:mm:ss tt")#')
>
> I keep getting the error message: ORA-01843: not a valid month
>
> Any ideas?
>
> Thanks,
> Scott
>
> ------_=_NextPart_001_01C00533.33F6C520
> Content-Type: text/html;
> charset="iso-8859-1"
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
>
>
> <META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
> <BODY>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>I am using the
> following statement to insert a date/time string into an Oracle table
(date
> field type):</FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>update
> MyTable</FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>set
> </FONT></SPAN><SPAN class=030583114-13082000><FONT face=Arial
size=2>API_UPDATE
> = TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
> tt")#')</FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>I keep getting
the
> error message: <FONT face="Times New Roman" size=3>ORA-01843: not a valid
month
> </FONT></FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000></SPAN> </DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial size=2>Any
> ideas?</FONT></SPAN></DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=030583114-13082000><FONT face=Arial
> size=2>Thanks,</FONT></SPAN></DIV>
> <DIV><FONT face=Arial size=2>Scott</FONT></DIV></BODY></HTML>
>
> ------_=_NextPart_001_01C00533.33F6C520--
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
