topic Re: Date Calculation in App Development

Date Calculation

jpjust — Wed, 17 Nov 2021 17:53:06 GMT

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 — Wed, 17 Nov 2021 18:19:35 GMT

Try this,

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

jpjust — Wed, 17 Nov 2021 18:42:21 GMT

Thanks Saravanan.

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