Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Local Timezone to UTC

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 2

Hi All,

Thanks for your inputs.Below code worked:

LocalToUTCSql.jpg

View solution in original post

4 Replies

Avatar

Level 4

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

Regards.

Avatar

Level 2

Hi asariaaara​, Thanks for the suggestion.

What do you mean options in Workflow properties? Timezone field in the General Tab?

This won't help either, when you use GetDate() function it still gives you the DB time which is set to my local time zone.

Thanks,

Vidya

Avatar

Level 4

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.

Avatar

Correct answer by
Level 2

Hi All,

Thanks for your inputs.Below code worked:

LocalToUTCSql.jpg