PostgreSQL and current_timestamp

Forum related to PostgreSQL

Moderators: gto, cipto_kh, EgonHugeist, olehs

Post Reply
MJFShark
Expert Boarder
Expert Boarder
Posts: 214
Joined: 04.06.2020, 13:59

PostgreSQL and current_timestamp

Post by MJFShark »

Hi All!

Is there something weird about Zeoslib's handling of PostgreSQL's current_timestamp? (or possibly with PostgreSQL's timezone support in general.)

I'm just doing a standard:
select current_timestamp;

And I always seem to get UTC time back instead of my current timezone's time. The timezone is set correctly on my server and database (I think!) current_time does show the correct time btw. All of my other databases seem to work correctly (or seem to work the way I'd expect.)

At first I thought it was just something strange about PostgreSQL's timezone handling, but running Postgre's SQL Shell (psql) on my machine (using the same client) shows current_timestamp correctly with the same query.

Any thoughts or ideas? Thanks!

-Mark
Post Reply