Site icon Parents Guides

How to “use” TIMESTAMP postgres data type

I have saved a datetime value created by Luxon into a postgres database column, of type TIMESTAMP(3). I want to then use that value, convert it into other time zones, etc. However, I can’t seem to figure out how to “use” it.

I created the object using the following

const { DateTime } = require("luxon");
const myDate = DateTime.now().toUTC().toISO()

I then inserted it into a postgres database, into a column of type TIMESTAMP(3).

I extract it out of the database using a query. When I log it, it says its value is:

console.log(extracted_date);                      //=> "2021-12-27T09:57:16.184Z"
console.log(typeof extracted_date);               //=> object

// The following return "unparsable" or undefined objects
DateTime.fromISO(extracted_date);
DateTime.fromObject(extracted_date);

I can find plenty of tutorials about how to insert dates into sql, but nothing on how to take that date object and actually do something with it. I want to, for instance, convert its time zone.

Exit mobile version