Convert date to YYYY-MM-DDThh:mm:ss.sssZ format in Postgresql

Question

I want to convert the date format to YYYY-MM-DDThh:mm:ss.SSSXXXZ (ISO 8601).

Getting 2021-02-10T04:02:55.55SXXXZ and it's wrong. I need it as 2021-02-10T04:02:55.55S000000Z.

select to_char(now(), 'YYYY-MM-DDThh:mm:ss.SSSXXXZ')

The `55S` (note the digit `5`) seems wrong. Did you mean `SSS` — , Feb 10 '21 at 06:45
I think you are looking for `select to_char(now(), 'YYYY-MM-DDThh:mm:ss.USZ');` — Adrian Klaver, Feb 10 '21 at 20:49

Kazi Mohammad Ali Nur Romel · Accepted Answer · 2021-02-10T06:16:15.717

5

For ISO 8601 date format you can use below query:

select to_char(now(), 'YYYY-MM-DD"T"HH24:MI:SS"Z"')

Output: "2021-02-10T12:09:17Z"

Is it your desired format?

edited Feb 10 '21 at 06:16

answered Feb 10 '21 at 06:00

1

2021-02-05T00:00:00.000000Z this is a sample. I need the output in this format. – Jithesh Nair Feb 11 '21 at 11:20
Is 2021-02-10T12:09:17Z ok? or you want 2021-02-10T12:09:17000Z? – Kazi Mohammad Ali Nur Romel Feb 11 '21 at 11:31

1 Answers1