Hi,
Need help on date conversion;
I have to convert data from one of my date columns
i.e., The incoming data is like 2008,28 then I have to convert it as 07-July-2008 (7th is the starting day of the 28th week in 2008 year).
Thanks in advance
Balaji
Full Version: Date Conversion
Hi Balaji,
unfortunately its no possible use "WW" mask for convert from char to date.
But you may still convert week to "day of year" [ (week-1)* 7 ] and use
to_date('2008 189','YYYY DDD')
or next conversion mask - "MON"
unfortunately its no possible use "WW" mask for convert from char to date.
But you may still convert week to "day of year" [ (week-1)* 7 ] and use
to_date('2008 189','YYYY DDD')
or next conversion mask - "MON"
Thanks for your valuable time, it is working ;-)
Balaji K
Balaji K
QUOTE (Littlewheat @ Jul 3 2008, 01:13 PM) 
Hi Balaji,
unfortunately its no possible use "WW" mask for convert from char to date.
But you may still convert week to "day of year" [ (week-1)* 7 ] and use
to_date('2008 189','YYYY DDD')
or next conversion mask - "MON"
unfortunately its no possible use "WW" mask for convert from char to date.
But you may still convert week to "day of year" [ (week-1)* 7 ] and use
to_date('2008 189','YYYY DDD')
or next conversion mask - "MON"
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.