topic DS2 Example Code - Datetime UTC in SAS Customer Intelligence

DS2 Example Code - Datetime UTC

carlialessandro — Tue, 23 May 2017 11:26:19 GMT

Hi all,

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:

"GETDATEINTIMEZONE(<<DateAndTime.today>>,'Europe/Rome')"
TODAY('Europe/Rome')

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.

Thank you,

Alessandro

Re: DS2 Example Code - Datetime UTC

shill — Wed, 24 May 2017 14:51:16 GMT

Alessandro -

Can you please clarify if this is something you're doing via DS2 or via a data insert process?

Steve

Re: DS2 Example Code - Datetime UTC

carlialessandro — Wed, 24 May 2017 14:58:22 GMT

Hi Shill, thank you for the reply.

I'm doing it via a data insert process, mapping a date variable of my table with the "Today's Date and Time" preconfigured SAS variable.

Re: DS2 Example Code - Datetime UTC

carlialessandro — Thu, 25 May 2017 17:03:00 GMT

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).

Thank you,

Alessandro

Re: DS2 Example Code - Datetime UTC

shill — Thu, 25 May 2017 17:16:29 GMT

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).

Re: DS2 Example Code - Datetime UTC

carlialessandro — Fri, 26 May 2017 08:11:25 GMT

Thank you so much for this SAS Note! I'll try to install the Hotfix and i'll let you know if it works.

Alessandro