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.