RE: RE: Oracle Time...again
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"
>
>
>
>
>
>
>
>
> I
am using the
> following statement to insert a date/time string into an Oracle
table
(date
> field type):
> size=2>
> update
> MyTable
> set
> API_UPDATE
> = TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
> tt")#')
> size=2>
> I
keep getting
the
> error message: ORA-01843:
not a valid
month
>
>
> Any
> ideas?
> size=2>
> size=2>Thanks,
> Scott
>
> --_=_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.
RE: RE: Oracle Time...again
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"
>
>
>
>
>
>
>
>
> I
am using the
> following statement to insert a date/time string into an Oracle
table
(date
> field type):
> size=2>
> update
> MyTable
> set
> API_UPDATE
> = TO_DATE('#DateFormat(Now(),"mm/dd/yy")# #TimeFormat(Now(),"hh:mm:ss
> tt")#')
> size=2>
> I
keep getting
the
> error message: ORA-01843:
not a valid
month
>
>
> Any
> ideas?
> size=2>
> size=2>Thanks,
> Scott
>
> --_=_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.
