Convert from JS timestamp to Postgresql Timestamp with time zone

Question

I have a simple t = Date.now; which goes to Postresql t_time column declared as timestamp with time zone via REST API. I got the error:date/time field value out of range.

I can't use the answer from this post as I don't write raw SQL but use ORM(Knex.Js). Calling db only to make the conversion looks like an overkill to me. Any other solution in js?

How come I can't find a convertor? Am I missing something?

Note: I just need date and time as hh:mm:ss, I don't need milliseconds.

Randy Casburn · Accepted Answer · 2019-06-29T20:18:20.687

19

Date.now() only provides the since EPOCH in milliseconds.

You need an ISO date time string. To achieve that, set t like this:

const t = new Date(Date.now()).toISOString();
console.log(t);

edited Jun 29 '19 at 20:18

answered Jun 29 '19 at 20:01

Randy Casburn

13,840
1
16
31

1

Nope! This *toISOString();* is what I was looking for. Added a hook, converted all time related data, works like magic! Thanks! – SharpBCD Jun 29 '19 at 20:17
Glad it's sorted. I'll remove the bit about EPOCH then. – Randy Casburn Jun 29 '19 at 20:18
leave it. Maybe somebody else will need it. – SharpBCD Jun 29 '19 at 20:18
3

`const t = new Date().toISOString()` suffices. – Gabriel S Jun 02 '22 at 18:04

score 1 · Answer 2 · answered May 29 '23 at 17:42

const getTIMESTAMPTZ = () => {
    const date = new Date();
    let offset = -date.getTimezoneOffset() / 60;
    const sign = (offset >= 0) ? '+' : '-';
    offset = Math.abs(offset);
    offset = (offset < 10) ? ('0' + offset) : offset;
    let TIMESTAMPTZ = date.toISOString();
    TIMESTAMPTZ = TIMESTAMPTZ.replace('T', ' ');
    TIMESTAMPTZ = TIMESTAMPTZ.replace('Z', `000${sign}${offset}`);
    return TIMESTAMPTZ;
};
console.log(' Example from PostgreSQL: ' + '2023-05-28 18:52:17.182883-07');
console.log('Output of getTIMESTAMPTZ: ' + getTIMESTAMPTZ());

score 0 · Answer 3 · answered Nov 22 '22 at 07:21

0

const t = Date.now().toString();
console.log(Date.now(), t);
const v = new Date(Number(t))
console.log(v);

answered Nov 22 '22 at 07:21

Vimal Prasad

1

Convert from JS timestamp to Postgresql Timestamp with time zone

3 Answers3