Convert postgres timestamp (+ timezone) to Date object [Javascript]

Question

Our postgres database returns a string with a timestamp: '2016-07-24T03:32:45.678Z'

We are trying to use the moment.js library, but it only accepts a Date object.

How can I convert the above timestamp+timezone into a Date object using Javascript?

Thank you for any help you can provide.

Moment accepts and in fact prefers strings. The best practice with moment is to never use a date object unless it has been given to you by a third party API. MOment should parse this time format by default when you pass it to the moment constructor. — Maggie Pint
– Maggie Pint, Commented Jul 24, 2016 at 14:13

Tarun Dugar · Accepted Answer · 2016-07-24 04:57:35Z

11

new Date(dateString.replace(' ', 'T'));

answered Jul 24, 2016 at 4:57

Tarun Dugar

8,9938 gold badges50 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user10207601 Over a year ago

some conversion of date is invalid.

isaacdre Over a year ago

@ManoharsinhRana: can you please clarify why this code would fail to convert some date strings / create an invalid conversion? Perhaps the confusion is that the O.P. stated that they needed to have this function work with a PG Timestamps WITH timezone... when their example shows +0, which is how Postgres stores timestamps without timezones (UTC / Unix Compatible). Thanks! Interested to hear your response!

user1835157 Over a year ago

why replace space with T? there's no space in OP's timestamp string.

Trevor · Accepted Answer · 2016-08-16 00:09:41Z

1

I needed to use moment(some_date).fromNow()

Instead of moment.startOf(some_date).fromNow()

answered Aug 16, 2016 at 0:09

Trevor

1,4743 gold badges16 silver badges33 bronze badges

Collectives™ on Stack Overflow

Convert postgres timestamp (+ timezone) to Date object [Javascript]

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related