Changing date format from YYYY-MM-DD to DD-MON-YY

vinothkumar · Post by **vinothkumar** » Wed Feb 12, 2014 8:33 am

Hi,
How can I change date format from "YYYY-MM-DD" to "DD-MON-YY" in parallel jobs.

Thanks
Vinoth

chulett · Post by **chulett** » Wed Feb 12, 2014 8:43 am

So... as strings, I assume?

crystal_pup · Post by **crystal_pup** » Wed Feb 12, 2014 9:25 am

DateToString(DSJobStartDate,"%dd-%mmm-%yyyy")

I used DSJobStartDate as an example, you can substitute it with your input date.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 12, 2014 3:27 pm

Date data types are stored in a binary form, so do not have formats.
To convert from one string representation to another, convert to and from Date data type with appropriate format strings. That is, use StringToDate() and DateToString() functions, assuming you're using a Transformer stage. Or date_from_string() and string_from_date() if you're using a Modify stage.

vinothkumar · Post by **vinothkumar** » Thu Feb 13, 2014 11:58 pm

Thanks. You guys rock as always..