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

03-07-2019

Hi,
Not a pro at SQL, but i guess timestamp will itself reflect timezone of system i.e. current timezone.

Maybe you should simply try without "with timezone Now()".

Let me know about the solution.  

Regards.