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