Date Formats
From: Mtek <mtek_at_mtekusa.com>
Date: Tue, 13 May 2008 10:43:44 -0700 (PDT)
Message-ID: <263e9d60-df36-4da4-b0db-69f89e7d8c5a@2g2000hsn.googlegroups.com>
Date: Tue, 13 May 2008 10:43:44 -0700 (PDT)
Message-ID: <263e9d60-df36-4da4-b0db-69f89e7d8c5a@2g2000hsn.googlegroups.com>
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! Received on Tue May 13 2008 - 12:43:44 CDT