Use JavaScript to convert a date string with timez

Question

The format of my date string looks like this: yyyy-MM-ddTHH:mm:ss-0Z00

Example 1: 2010-03-05T07:03:51-0800

Example 2: 2010-07-01T20:23:00-0700

I need to create a date object using these date strings. new Date() does not work on this string. Please help me convert these date strings into a date objects with the local timezone.

Thank you!

Edit: I am using this in Pentaho Data Integration 4.3.0.

Answer 1

Take my timezone as an example (AEST):

function parseDate(str_date) {
  return new Date(Date.parse(str_date));
}


var str_date = "2015-05-01T22:00:00+10:00"; //AEST time
var locale_date = parseDate(str_date);

locale_date: Fri May 01 2015 22:00:00 GMT+1000 (AEST)

var str_date = "2015-05-01T22:00:00+00:00" //UTC time
var locale_date = parseDate(str_date);

locale_date: Sat May 02 2015 08:00:00 GMT+1000 (AEST)

Answer 2

You can use a library such as Moment.js to do this.

See the String + Format parsing.

http://momentjs.com/docs/#/parsing/string-format/

The following should parse your date you provided, but you may need to modify it for your needs.

var oldDate = "2010-03-05T07:03:51-0800";

var dateObj = moment(oldDate, "YYY-MM-DDTHH:mm:ssZ").toDate();

Alternatively, see Moment's String parser, which looks like it is in the format you provided, with the exception of a space between the seconds of the time and the time zone.

http://momentjs.com/docs/#/parsing/string/

Alternative

A second way of doing this is Date.js, another library that seems to parse the format just fine. http://www.datejs.com

Answer 3

Date String:

var strDate = "2010-07-01T20:23:00-0700";

To local time representation in native JS Date object:

var ltzDate = (new Date(strDate)).toLocaleString();