 | |
#1
 
| |||
| |||
|
Date Formats -
05-13-2008
, 12:43 PM
#2
| |||
| |||
|
|
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
#3
| |||
| |||
|
|
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
#4
| |||
| |||
|
|
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
#5
| |||
| |||
|
|
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
#6
| |||
| |||
|
|
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.
#7
| |||
| |||
|
|
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.
#8
| |||
| |||
|
|
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.
#9
| |||
| |||
|
|
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.
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.