Date function
941976Jun 25 2012 — edited Jun 25 2012Hi,
My requirement is below
In a source table the date column have different length of the date values i.e.(23,454,2342...) like it goes till 6 digit length. I want to move all the date values to target table using function to validate all the diff date lengths
I wnt to get the output in this format 'YYMMDD'
I want to write a function for the above scenario and also, while considering the year (which in source table is just 2 digits), if the year is less than 20, then use century as 20. If year is > 20 then use the century as 19.