Local Timezone to UTC | Community
Skip to main content
vidyas77336264
vidyas77336264
Level 2
July 1, 2019
Solved

Local Timezone to UTC

  • July 1, 2019
  • 4 replies
  • 4079 views

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.

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by vidyas77336264

    Hi All,

    Thanks for your inputs.Below code worked:

    4 replies

    A
    asariaaara
    Level 3
    July 1, 2019

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

    Regards.

      vidyas77336264
      vidyas77336264Author
      Level 2
      July 3, 2019

      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

      A
      asariaaara
      Level 3
      July 3, 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.

        vidyas77336264
        vidyas77336264AuthorAccepted solution
        Level 2
        July 8, 2019

        Hi All,

        Thanks for your inputs.Below code worked:

        Terms & ConditionsAccessibility statement

        Loading footer...