Scott,
You could update using 'Sysdate' which will update the
record with date and time. I havent been using oracle in
a while, look at what 'sysdate' inserts and pass the sql string
in same format.
Hope this helps.
Thanks
Joe
--- Original Message ---
Scott Mulholland <[EMAIL PROTECTED]> Wrote on
Mon, 14 Aug 2000 08:13:03 -0400
------------------
Joe,
Thanks for the reply...I am not having any issues with the date,
I can
insert/update these with no problem, it is when I try to capture
the time as
well that it is failing.
Scott
-----Original Message-----
From: Joseph Eugene [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 5:02 PM
To: [EMAIL PROTECTED]
Subject: Re: Oracle Time...again
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.
------------------------------------------------------------------------------
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.
-----
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
------------------------------------------------------------------------------
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.