nodejs convert timestamp string into date with custom timezone and to UTC

Question

Suppose i get the value '2014-03-03 16:20:20' as an input, I'd like to convert it to it's real time with timezone (i.e, node sits in Europe , but timestamp was collected in America), and after that I'd like to get the UTC representation of the real value.

Any idea what packages can help? Tried moment.js with no luck..

you requirement is getting time from client and trust that instead of using server time? — wayne
– wayne, Commented Mar 11, 2014 at 13:42
requirement is get user's date in 'YYYY-MM-DD hh:mm:ss' format, convert it to a UTC date according user's timezone — Pavel 'PK' Kaminsky
– Pavel 'PK' Kaminsky, Commented Mar 11, 2014 at 13:45
Are you collecting the input in a web browser? Why not just convert to UTC there, so you don't have to involve time zones at all? Why does it have to be done on in node.js server side code? — Matt Johnson-Pint
– Matt Johnson-Pint, Commented Mar 11, 2014 at 15:12
because it's not a browser, it's a legacy code on hardware which cannot be modified and always set to a particular and fixed TZ. — Pavel 'PK' Kaminsky
– Pavel 'PK' Kaminsky, Commented Mar 12, 2014 at 11:01
Related: How to initialize javascript date to a particular timezone — Matt Johnson-Pint
– Matt Johnson-Pint, Commented Mar 13, 2014 at 16:33

Pavel 'PK' Kaminsky · Accepted Answer · 2014-03-12 14:19:50Z

2

finally found the answer with momentjs-timezone ,

which is kinda funny since you wont get a event a hint about on the mainsite http://momentjs.com/timezone/ but you can find it on http://github.com/moment/moment-timezone

anyhow here's how you do it :

var tz0 = moment.tz("2014-03-03 16:20:20", "Asia/Jerusalem")
var tz1 = moment.utc(tz0);


console.log(tz0.format('YYYY-MM-DD hh:mm:ss'));
console.log(tz1.format('YYYY-MM-DD hh:mm:ss'));

and the output as you can see respectivly

2014-03-03 04:20:20
2014-03-03 02:20:20

edited Mar 12, 2014 at 14:19

answered Mar 12, 2014 at 14:13

Pavel 'PK' Kaminsky

8061 gold badge11 silver badges23 bronze badges

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

Comments

wayne · Accepted Answer · 2014-03-11 14:01:26Z

0

// moment.js

var utc = moment('2014-03-03 16:20:20','YYYY-MM-DD HH:mm:ss', 'us');
// or timezone string pass from client

var eu = utc.zone("+02:00");
var eu = utc.zone("-02:00");

answered Mar 11, 2014 at 14:01

wayne

3,41022 silver badges11 bronze badges

2 Comments

Pavel 'PK' Kaminsky Over a year ago

what if i don't know the zone time difference ("+02:00")? what if i want to pass the "us" time and convert to local, and then to UTC?

wayne Over a year ago

you check, preload a table with time diff. select the one you need at runtime. eu timezone is not that many

Ron · Accepted Answer · 2014-03-11 14:10:19Z

0

momentjs may help you. Like the following:

Could you format the input with ISO date plus timezone info, like 2014-03-03T16:20:20-05:00 (supposing you get from local time at GMT-5 timezone)
Then call: moment.parseZone('2014-03-03T16:20:20-05:00').zone(1).format() (supposing you want to get local time at GMT+1 timezone)

Hope that help, Ron

answered Mar 11, 2014 at 14:10

Ron

6,8355 gold badges39 silver badges58 bronze badges

Comments

Avinash · Accepted Answer · 2014-03-11 15:17:34Z

0

Timezone is an elegant module for this.

var tz = require("timezone/loaded");
var formattedDate = tz(unformattedTimestamp, '%d %B %Y, %-I:%M %p', "Europe/Amsterdam");

You can use bootstraphelper to capture user's timezone.

edited Mar 11, 2014 at 15:17

answered Mar 11, 2014 at 14:45

Avinash

7797 silver badges18 bronze badges

Collectives™ on Stack Overflow

nodejs convert timestamp string into date with custom timezone and to UTC

4 Answers 4

Comments

2 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Linked

Related