Re: Date Conversion
From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 27 Jul 2006 13:29:12 GMT
Message-ID: <J32DGq.49B_at_igsrsparc2.er.usgs.gov>
Date: Thu, 27 Jul 2006 13:29:12 GMT
Message-ID: <J32DGq.49B_at_igsrsparc2.er.usgs.gov>
pawan_test wrote:
> Hello,
>
> the output is : Jul 25
> my desired output is: 0725
> this is because i have to load into a table in the format MMDD
How do you plan on loading this into the table? Oracle will not store the date datatype in any of the formats listed above. But you can take the format above and convert it to a date datatype with the TO_DATE function.
TO_DATE('Jul 25','MON DD')
Just because the date is in one format, you can ingest it into the date datatype with a simple conversion....
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Thu Jul 27 2006 - 15:29:12 CEST