date function

femil · Post by **femil** » Sat Nov 28, 2009 11:18 am

what function is used to get the current date format of 'DD-MON-YY' in datastage transformer

chulett · Post by **chulett** » Sat Nov 28, 2009 11:49 am

Two steps, actually. Date() or @DATE will get it in internal format then OConv() can convert it to any format. Or Field(TimeDate()," ",1,3) but you'll still need to 'adjust' the output.

femil · Post by **femil** » Sat Nov 28, 2009 12:14 pm

thank you and which gives the better performance field or conv function

chulett · Post by **chulett** » Sat Nov 28, 2009 12:20 pm

Really shouldn't matter as you should do this in the Initial Value of a stage variable so it is only derived once. Unless you need to change the value when the job starts before but runs past midnight?

ray.wurlod · Post by **ray.wurlod** » Sat Nov 28, 2009 3:53 pm

@DATE gives the better performance, because it's set when the job starts and does not change thereafter. Date(), on the other hand, accesses the system clock to give the current date - which may be different than when the job started, particularly in an "always running" job. So what is it you are really after, performance or correctness?