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?
Populating Date/time values in CET format
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.