Re: Date Formats
From: Mtek <mtek_at_mtekusa.com>
Date: Tue, 13 May 2008 11:50:04 -0700 (PDT)
Message-ID: <428623e2-cd2b-463c-8bdd-3762c71428a3@k37g2000hsf.googlegroups.com>
Date: Tue, 13 May 2008 11:50:04 -0700 (PDT)
Message-ID: <428623e2-cd2b-463c-8bdd-3762c71428a3@k37g2000hsf.googlegroups.com>
On May 13, 12:54 pm, Urs Metzger <u..._at_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. Received on Tue May 13 2008 - 13:50:04 CDT