Re: Date Formats
From: Urs Metzger <urs_at_ursmetzger.de>
Date: Tue, 13 May 2008 19:54:16 +0200
Message-ID: <g0ckj4$qq1$1@online.de>
Date: Tue, 13 May 2008 19:54:16 +0200
Message-ID: <g0ckj4$qq1$1@online.de>
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
Received on Tue May 13 2008 - 12:54:16 CDT