Is the Date parsing fix in the current pg release? #138
Comments
|
|
Leitsi
added a commit
to HSLdevcom/jore4-hasura
that referenced
this issue
Feb 27, 2023
…ne for luxon Merely adding the luxon default timezone was not quite enough: broke on CI, which uses utc -> pg returned JS dates in UTC (DB itself returns them as YYYY-MM-DD strings) which did not match luxon dates they were compared with. Now all luxon objects are in Finland timezone, and tests still work no matter what timezone the runner is. Some related links: knex/knex#3071 https://node-postgres.com/features/types#date--timestamp--timestamptz brianc/node-pg-types#138
Leitsi
added a commit
to HSLdevcom/jore4-hasura
that referenced
this issue
Feb 28, 2023
…ne for luxon Merely adding the luxon default timezone was not quite enough: broke on CI, which uses utc -> pg returned JS dates in UTC (DB itself returns them as YYYY-MM-DD strings) which did not match luxon dates they were compared with. Now all luxon objects are in Finland timezone, and tests still work no matter what timezone the runner is. Some related links: knex/knex#3071 https://node-postgres.com/features/types#date--timestamp--timestamptz brianc/node-pg-types#138
Leitsi
added a commit
to HSLdevcom/jore4-hasura
that referenced
this issue
Mar 1, 2023
…ne for luxon Merely adding the luxon default timezone was not quite enough: broke on CI, which uses utc -> pg returned JS dates in UTC (DB itself returns them as YYYY-MM-DD strings) which did not match luxon dates they were compared with. Now all luxon objects are in Finland timezone, and tests still work no matter what timezone the runner is. Some related links: knex/knex#3071 https://node-postgres.com/features/types#date--timestamp--timestamptz brianc/node-pg-types#138
Leitsi
added a commit
to HSLdevcom/jore4-hasura
that referenced
this issue
Mar 1, 2023
…ne for luxon Merely adding the luxon default timezone was not quite enough: broke on CI, which uses utc -> pg returned JS dates in UTC (DB itself returns them as YYYY-MM-DD strings) which did not match luxon dates they were compared with. Now all luxon objects are in Finland timezone, and tests still work no matter what timezone the runner is. Some related links: knex/knex#3071 https://node-postgres.com/features/types#date--timestamp--timestamptz brianc/node-pg-types#138
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I found #50 because I noticed my Postgres DATE columns were returning as
'yyyy-MM-ddThh:mm:ss.mssZ'instead of'yyyy-MM-dd'. It looks like the fix #121 by @ianwalter was merged almost two years ago, but I am still encountering this date parsing issue on pg 8.7.3 and node 14.18.3.Currently I am using the workaround mentioned in the first issue
The text was updated successfully, but these errors were encountered: