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/[email protected]/
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.
