Postgresql date inconsistent format

Question

I am building an app using node with a Postgres backend. I have a column for date where the data type is date. The dates in the database are stored in the format YYYY-MM-DD. However, when I do a query in my app, the date returned is in the format YYYY-MM-DD + (time zone information). For example:

2016-01-06T05:00:00.000Z

Does anyone know how I can prevent this?

Thanks in advance!

tkone · Accepted Answer · 2016-01-06 18:06:25Z

1

Use to_char

SELECT to_char(dateColumn, 'YYYY-MM-DD') AS formattedDate FROM ...

Example:

ubuntu=> SELECT to_char(to_timestamp('2016-01-07', 'YYYY-MM-DD'), 'YYYY-MM-DD');
  to_char
------------
 2016-01-07
(1 row)

answered Jan 6, 2016 at 18:06

tkone

22.8k5 gold badges57 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql date inconsistent format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related