RE:Dates

m_siddu2000 · Post by **m_siddu2000** » Wed Nov 01, 2006 1:08 am

How to convert date (sql type =varchar) 01/01/06 to January 1, 2006?
Could anyone tell me, about how to do.

kumar_s · Post by **kumar_s** » Wed Nov 01, 2006 3:05 am

I don't have access to PX, but you can convert it using database stage by TO_CHAR(SYSDATE,'Month DD,YYYY').

ray.wurlod · Post by **ray.wurlod** » Wed Nov 01, 2006 8:09 am

Use date_from_string (Modify stage) or StringToDate (Transformer stage) to convert the date into a string, supplying an approprate date format string.
Use string_from_date (Modify stage) or DateToString (Transformer stage) to convert that result into a string of the desired format, again supplying an appropriate date format string.