Local Timezone to UTC

Avatar

Avatar

vidyas77336264

Avatar

vidyas77336264

vidyas77336264

30-06-2019

Hi All,

I'm building a custom adobe campaign classic function to convert current date to UTC. But irrespective of what method I use, I'm getting nowhere. Getting below errors.

Custom_SQL_Function.jpgCustom_SQL_Function_Error.jpg

Where am I going wrong? Can we convert Local time to UTC in postgres?

Note: I can do it using JS activity but won't be able to create a custom function.

I have also tried with: select Timestamp with '2019-07-01 10:30:00-05' AT TIME ZONE 'UTC'.

Thanks,

Vidya Shivakumar

View Entire Topic

Avatar

Avatar

asariaaara

Avatar

asariaaara

asariaaara

01-07-2019

Hi vidyas77336264​,
Cant you directly use the option found in properties of workflow.

Regards.