05-23-2017 07:26 AM
i'm using RTDM 6.4, I need to create a new DATE variable to write the correct sysdate (Timezone: Europe/Rome) on a staging table. I must write it in a TIMESTAMP field mapping the related insert viariable of an insert data process. I tried to use the "Today's Date and Time" Out of the Box variable but i've seen that it writes always the UTC datetime. I also tried to use the following conversion functions in the calculated variable editor but the date written on DB is always in UTC:
Any suggestions about the calculation of a new variable, even in DS2 code, to write the correct italian sysdate also respect the change from solar to legal time.
a month ago
Just to explain better,
I would also like to know if there is a way, building a DS2 process, to create a date variable to be mapped in the data insert process. I need this date variable to have the correct italian time at every runtime( in DST and standard time).
a month ago
Have you applied the hotfix and configuration options from this SAS Note? You shouldn't need a DS2 process - if all your dates are in CET, there won't be any conversion needed once that's in place and set as your default TZ. If you have dates from other TZ's, then the calculated item functions you mentioned would be appropriate to convert it to CET as the input variable to a data process (which will now, per this fix, write it in CET).