PostgreSQL and current_timestamp
Posted: 02.03.2021, 16:29
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
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