what is the default of DSJobStartDate

vasam · Post by **vasam** » Sat Apr 24, 2010 1:52 am

Hi All,

Could please telll me the what is the default format of DSJobStartDate:

in my job its giving yyyy-mm-dd..

I want to convert into yyyymmdd. is there any way to do that?

could you pls suggesst me

Thanks,
Vijay

chulett · Post by **chulett** » Sat Apr 24, 2010 6:31 am

Strip out the delimiters, convert() comes to mind.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 24, 2010 3:55 pm

DSJobStartDate invoked from a Transformer stage is a Date. Therefore it has no default format or, indeed, any format - it's stored as a binary quantity. The only way to get a format is to convert the date to a string, for which the appropriate function in a Transformer stage is StringToDate() - or in a ModifyStage date_from_string() - in which you can specify the required date format.

chulett · Post by **chulett** » Sat Apr 24, 2010 4:26 pm

Or that.