PostgreSQL time formatting

Question

Is there any way to format timestamp to the following format in PostgreSQL?

2019-10-14T16:16:47.026Z

Gordon Linoff · Accepted Answer · 2019-10-25 11:49:02Z

1

I believe you want:

select to_char(col, 'YYYY-MM-DD"T"HH:MI:SS.MSTZ')

Of course, the timezone depends on the timezone for the value.

answered Oct 25, 2019 at 11:49

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

2 Comments

it gives "syntax error" for current situation. I need the same solution, please.

cursor.execute("SELECT to_char(time, 'YYYY-MM-DD"T"HH:MI:SS.MSTZ),temperature FROM conditions WHERE time > NOW() - interval '1000 days';")