Date Calculation

[jpjust]

Al,

I have an date value like this  - 2021-11-17T05:18:22.209219-08:00

Now, I want only 2021-11-17 05:18:22 AM    (If PM, then PM)

Please let me know how to achieve this.

Thanks

[Saravanan_Desingh]

Try this,

Timestamp('2021-11-17T05:18:22.209219-08:00')

[jpjust]

Thanks Saravanan.

It is getting covered to UTC. How can I preserve local server time (pacific time zone)?