Populating Date/time values in CET format

[snt_ds]

Hi GURUs,
My project "XXXXXX" wants all date time functions to be in CET(central european time), like all the date/time things on the report should have CET. But the job will be run in USA,which is Eastern standard time(CET = ESt + 6 Hours).
Now the problem is if there are like 1000 records it will be an overhead to convert time on each of them to CET because the server will always generate the USA time.so is there any solution/suggestion from you GURU's to simplify the process?

[keshav0307]

you can have a parameter to this job, assign that to (ESt + 6 Hours); and use this parameter whereever you are using current_date

[DSguru2B]

These functions are pretty swift. Before you can blink, it would process thousands of records and add 6 hours to it. Did you run a benchmark test for this. Just throw in a row generator, pass it through a transformer and add 6 hours to the current time. Test it out for your max anticipated number of rows, plus 50,000 more. See if that time takes is acceptable by your time window.
Another thing you can do, is to set a stage variable's initial value with your CET time. This way it will only be calculated once per job run.

[chulett]

Umm... Daylight Saving Time?