Help - Search - Members - Calendar
Full Version: Date Conversion
Oracle DBA Forums > Oracle > Oracle Forum
Balaji Kaligatla
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
Littlewheat
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"
Anand.Varma
Thanks for your valuable time, it is working ;-)

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"
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.