topic Today's Date and Time variables in SAS RTDM in SAS Customer Intelligence

Today's Date and Time variables in SAS RTDM

psmerill — Tue, 30 Oct 2018 11:59:03 GMT

Hi,

we need to write a current datetime value into a custom table using a data process into a decision campaign in SAS RTDM.
We try to use "Today's Date and Time" variables for set the output datetime variable, but into custom table the hours are written with two/one hours forward (depending on the solar or legal time) respesct Europe/Rome timezone.

Nonetheless,the datatime on the sas logs and commonon data model tables are write with the correct time.

How can we insert into custom table the correct datatime for Europe/Rome timezone?

Best regards,
Paolo

Re: Today's Date and Time variables in SAS RTDM

JamesAnderson — Wed, 31 Oct 2018 00:04:00 GMT

HI Paolo,

By default the system thinks it is in GMT timezone.

You can change this by following the instructions here: http://support.sas.com/kb/55/831.html.

Regards

James

Re: Today's Date and Time variables in SAS RTDM

psmerill — Wed, 07 Nov 2018 14:16:58 GMT

Hi James,

thank you for the answer, the FIX into sas note above refer to Oracle DB. We use Teradata, the Fix still work?

Best regards,
Paolo

Re: Today's Date and Time variables in SAS RTDM

JamesAnderson — Wed, 07 Nov 2018 21:44:04 GMT

HI Paulo,
Yes - it sets the time zone on the RTDM server, so that when the datetime is passed to the database (any database) the time zone is already interpreted and the value will be correct.
Rgds
James