PostgreSQL 9.6 Cast text datetime to timetamptz different results
Why may I have different results of casting text datetime to timestamptz on my Postgres server?
The first date casts to +03, but the second one casts to +04. Why?
I have Postgres 9.6, my config:
datestyle = 'iso, mdy';
timezone = 'W-SU';
lc_time = 'ru_RU.UTF-8'
Solution
There must be a daylight savings time change between these two dates, so that in your session time zone (determined by the current setting of the timezone parameter) a different UTC offset is used.
W-SU is an alias for Europe/Moscow, and Moscow changed from daylight savings time in the night from Oct 25 (Saturday) to Oct 26 (Sunday).
- To select a specific column from a table using php postgres
- PGError: ERROR: column “recipes.id” must appear in the GROUP BY clause or be used in an aggregate function
- Use functions in unique constraint on multiple columns
- psql: FATAL: Ident authentication failed for user "postgres"
- Update record of a cursor where the table name is a parameter
- How do I (or can I) SELECT DISTINCT on multiple columns?
- How list all tables with data changes in the last 24 hours?
- Unable to delete duplicate rows with PostgreSQL
- Delete duplicate rows from small table
- How to delete duplicate rows without unique identifier
- In-order sequence generation
- SQLAlchemy SELECT WITH clause/statement (pgsql)
- Accidentally restored a another database to the 'postgres' database how to correct
- MERGE RETURNING into temp table without a CTE
- How do I delete a fixed number of rows with sorting in PostgreSQL?
- Can't subtract offset-naive and offset-aware datetimes
- How can I get Postgres use my functional index
- What is the correct way to implement a context manager in psycopg2?
- Can Postgres silently ignore column constraint conflicts?
- How to LIMIT the number of parent values, but return all children for each?
- Get the first date of an ISO 8601 year and week
- how can i get the last row with a given foreign key in yii2 with relations?
- Nifi : How to move CSV content and its meta data to single table in Postgresdatabase using NiFi
- SQLAlchemy hangs when sending ALTER TABLE
- log4net:ERROR ConfigureFromXml called with null 'element' parameter for Postgres SQL
- Postgres - SQL Recursivity to get the highest parent
- RDS while connection error: no pg_hba.conf entry for host
- Best way to select random rows PostgreSQL
- How to list indexes created for table in postgres
- How do you change a user in PostgreSQL?