This content has been marked as final. Show 4 replies
did you tryed with TO_DATE function..
to_date('29-Oct-09', 'DD-Mon-YY HH:MI:SS')
to_date('Oct/29/09', 'Mon/DD/YY HH:MI:SS')
my data is like this
jan-11,aug-11,mar-11 like this varchar
how to use todate for this convert to mm-yy format
my suggestion is first convert char to date using TO_Date in column formula by using Evaluate function ->ok
then goto column properties-->data format-->customformat-->MM-YY
try it once..
You may have to go manual conversion for each month like
(case when substring('jan-11',1,3)='jan' then '01'
when substring('jan-11',1,3)='feb' then '02
end) || substring('jan-11',4,6)
Try to extend this to further months..
If helps pls mark as correct/helpful