Date Formats
This is a discussion on Date Formats within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hi, Here is the date format coming in on the input file: Apr 7 2009 12:00AM So, if the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-13-2008, 07:14 PM
| ||||
| ||||
 Date Formats Hi, Here is the date format coming in on the input file: Apr 7 2009 12:00AM So, if the AM / PM is coded there, how can I put that into the format string? I'll be using this in an external table setting... TO_DATE(Apr 7 2009 12:00AM,'Mon DD YYYY HH12:MI.......... Thanks!      |
|
05-13-2008, 07:14 PM
| |||
| |||
| Re: Date Formats Mtek schrieb: > Hi, > > Here is the date format coming in on the input file: Apr 7 2009 > 12:00AM > > So, if the AM / PM is coded there, how can I put that into the format > string? I'll be using this in an external table setting... > > TO_DATE(Apr 7 2009 12:00AM,'Mon DD YYYY HH12:MI.......... > > Thanks! TO_DATE('Apr 7 2009 12:00AM' ,'Mon DD YYYY HH12:MIPM') hth, Urs Metzger |
|
05-16-2008, 02:40 PM
| ||||
| ||||
| Re: Date Formats On May 13, 12:54*pm, Urs Metzger <u...@ursmetzger.de> wrote: > Mtek schrieb:> Hi, > > > Here is the date format coming in on the input file: * Apr *7 2009 > > 12:00AM > > > So, if the AM / PM is coded there, how can I put that into the format > > string? *I'll be using this in an external table setting... > > > TO_DATE(Apr *7 2009 12:00AM,'Mon DD YYYY HH12:MI.......... > > > Thanks! > > TO_DATE('Apr *7 2009 12:00AM' ,'Mon DD YYYY HH12:MIPM') > > hth, > Urs Metzger Thank you very much. |
 |
« Oracle chief architect says there ought to be one Linux distribution:Red Hat
|
ORA-04091 Question »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 07:30 AM.
