Question

191

Converting a datetime string to timestamp in Javascript

rated 0 times [ 192] [ 1] / answers: 1 / hits: 128343 / 11 Years ago, tue, september 17, 2013, 12:00:00

Question in brief:

What is the easiest way to convert date-month-year hour(24):minute to timestamp?

due to more views add clear question on the top, so that no need to go through background & all if need quick help.

Background :

I have a simple html table and I used jquery sorter to sort my table columns.

Everything is working fine except a date column which is having following format of data,

17-09-2013 10:08

date-month-year hour(24):minute

This column is sorting(alphabetically) but not as I expected(date wise). I tried to use a custom parser as follows,

$.tablesorter.addParser({ 

    id: 'date_column',  // my column ID

    is: function(s) { 

        return false; 

    }, 

    format: function(s) { 

        var timeInMillis = new Date.parse(s);

        return timeInMillis;         

    }, 

    type: 'numeric' 

});

Problem :
it fails due to new Date.parse(s) .

Question :
what is the easiest way to convert date-month-year hour(24):minute to timestamp? then I can skip var timeInMillis = new Date.parse(s); line.

Thanks

Edited :

Sorry about the confusion about milliseconds, actually it should be the timestamp which is a number that represents the current time and date.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

christianu

Add To Favorites

Follow

Total Points: 481

Total Questions: 124

Total Answers: 99

Location: Trinidad and Tobago

Member since Thu, Dec 1, 2022

2 Years ago

christianu questions

1 Having a trouble with Google OAuth2 (app has no backend, so client side only)

Mon, May 9, 22, 00:00, 2 Years ago

1 Change Icon on click with JS

Thu, Mar 10, 22, 00:00, 2 Years ago

1 Svelte: is there a way to cache the api result in a way that it won't trigger the api call everytime the component renders?

Sun, Sep 27, 20, 00:00, 4 Years ago

1 Javascript / React use of square brackets

Sun, Jul 5, 20, 00:00, 4 Years ago

1 Cannot POST to Express router (404 error)

Wed, Jun 17, 20, 00:00, 4 Years ago

View All

answered 11 Years ago ryder · Accepted Answer

Parsing dates is a pain in JavaScript as there's no extensive native support. However you could do something like the following by relying on the Date(year, month, day [, hour, minute, second, millisecond]) constructor signature of the Date object.

var dateString = '17-09-2013 10:08',

    dateTimeParts = dateString.split(' '),

    timeParts = dateTimeParts[1].split(':'),

    dateParts = dateTimeParts[0].split('-'),

    date;



date = new Date(dateParts[2], parseInt(dateParts[1], 10) - 1, dateParts[0], timeParts[0], timeParts[1]);



console.log(date.getTime()); //1379426880000

console.log(date); //Tue Sep 17 2013 10:08:00 GMT-0400

You could also use a regular expression with capturing groups to parse the date string in one line.

var dateParts = '17-09-2013 10:08'.match(/(d+)-(d+)-(d+) (d+):(d+)/);



console.log(dateParts); // [17-09-2013 10:08, 17, 09, 2013, 10, 08]