Not getting date-time in specific format in PostgreSQL

Question

What I'm trying is

SELECT TO_CHAR(NOW(), 'YYYY-MM-DDTHH24:MI:SS.US');

Actual Output:

           to_char            
------------------------------
 2021-06-17THH24:05:19.815403

but my Expected output:

           to_char            
------------------------------
 2021-06-17T06:05:19.815403

here When I use T then hour print like HH24.

Jim Jones · Accepted Answer · 2021-06-17 06:11:04Z

2

Try placing the T between double quotes:

SELECT to_char(now(), 'YYYY-MM-DD"T"HH24:MI:SS.US');
          to_char           
----------------------------
 2021-06-17T08:11:11.913287

answered Jun 17, 2021 at 6:11

Jim Jones

19.9k3 gold badges44 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

G T Over a year ago

one more thing, what does T represent in the datetime and what is US?

Jim Jones Over a year ago

@GT T is a string you've chosen and US means microsecond (000000-999999). Check this tutorial: postgresqltutorial.com/postgresql-to_char

G T Over a year ago

So there is no specific meaning of T. Thank you

Jim Jones Over a year ago

@GT well, at least I'm not aware of T and the to_char tutorial does not mention it. But I cannot speak for the whole standard :) cheers and happy coding.

Collectives™ on Stack Overflow

Not getting date-time in specific format in PostgreSQL

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related