timestamp

Debian – Why pg_typeof(TIMESTAMP '2004-10-19 10:23:54+02') shows timestamp without time zone

From docs https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-DATETIME-INPUT-TIME-STAMPS TIMESTAMP '2004-10-19 10:23:54+02' is a timestamp with time zone Question: Why select pg_typeof(TIMESTAMP '2004-10-19 10:23:54+02'); gives timestamp without time zone? Expecting timestamp with time zone as docs say. Postgres version SELECT version(); shows PostgreSQL 14.14 (Debian 14.14-1.pgdg120+1)…

VIEW QUESTION

Postgresql – Generate timestamp series between given dates

Given min and max dates are: Min date: 2023-06-19 09:54:23.000 Max date: now()::timestamp(0)-interval '1 year' Expected output: start_date end_date ------------------------------------------- 2023-12-01 00:00:00.000 2023-12-09 23:59:59.999 2023-11-01 00:00:00.000 2023-11-30 23:59:59.999 2023-10-01 00:00:00.000 2023-10-31 23:59:59.999 2023-09-01 00:00:00.000 2023-09-30 23:59:59.999 2023-08-01 00:00:00.000 2023-08-31 23:59:59.999…

VIEW QUESTION
Back To Top
Search