Postgres date column being treated as TIMESTAMP

Skip to first unread message

Shyam Katti

Aug 7, 2020, 10:52:51 AM8/7/20
to LoopbackJS
I am using Loopback 4 with Postgres connector. Following is the definition of a date column:
Screen Shot 2020-08-07 at 8.19.17 PM.png

The database has it defined as DATE type. I enabled debugging on the app server and it looks like Loopback is treating the column as a TIMESTAMP with TIMEZONE column
Screen Shot 2020-08-07 at 8.21.33 PM.png

This seems to causing the actual date value as being -1 DAY from the value. Would that be correct to assume? How can I go about fixing it?

Appreciate your help.

Reply all
Reply to author
0 new messages