How to save JS Date.now() in PostgreSQL?

Question

I tried to use PostgreSQL timestamp datatype, but it throws an error

ERROR:  date/time field value out of range: "1489849402536" 

The schema

create table times (   time   timestamp    not null, ); 

JS code

`insert into times(time) values (${Date.now()})` 

P.S. another option is to use bigint but it seems like an overkill.

Answer 1

Use the to_timestamp() postgres function:

`insert into times (time) values (to_timestamp(${Date.now()} / 1000.0))` 

Answer 2

Or you can do something similar to this:

const time = new Date().toISOString(); 

In your query builder:

... .update() .set({column_name: time})