How to select date with timezone in Postgresql?

Question

I want to retrieve the daily number of signups recorded in Berlin timezone, but by default my database is using timezone '-08'. How do I do a select statement while specifying timezone?

Maxim Sloyko · Accepted Answer · 2011-02-21 11:05:23Z

25

select some_date at time zone 'Europe/Berlin' from some_table

answered Feb 21, 2011 at 11:05

Maxim Sloyko

16k9 gold badges46 silver badges50 bronze badges

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

Comments

Scott Marlowe · Accepted Answer · 2011-02-22 06:35:16Z

4

So are you looking for timezone the client was in when they registered? If you don't record it it's gone. timestamptz or timestamp with timezone converts from local timezone to GMT on the way in, and GMT to local on the way out. It does not store the current timezone. It simply adjusts inputs and outputs to it. If you need to store the timezone you need to store it in another column when you create or update the row.

answered Feb 22, 2011 at 6:35

Scott Marlowe

9,0403 gold badges27 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to select date with timezone in Postgresql?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related