I am using Knex query builder with Postgres in my application. I am trying to add a created_at and updated_at fields in my database with ISO8016 formatted data in UTC time. I am trying to have my data look like this:
2017-04-20T16:33:56.774Z
In my Knex migrations, I have tried using both the .timestamps() method creating both created_at and updated_at manually with the .timestamp() method and naming them myself.
When I seed my database and set created_at and updated_at equal to moment().utc().toISOString(), but it stores in my database as this:
2017-04-20 11:20:00.851-05
There is something between the code and the database changing the data and I don't know if it's Knex, the Postgres Node library, or Postgres itself.
via lgh
No comments:
Post a Comment