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.