Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Converting Date and Time To Unix Timestamp

I'm displaying the date and time like this

24-Nov-2009 17:57:35

I'd like to convert it to a unix timestamp so I can manipulate it easily. I'd need to use regex to match each part of the string then work out the unix timestamp from that.

I'm awful with regex but I came up with this. Please suggest improvements ^.^

/((\d){2}+)-((Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)+)-((\d){4}+) ((\d){2}+):((\d){2}+):((\d){2}+)/gi 

How can I do this?

like image 233
Ben Shelock Avatar asked Nov 24 '09 18:11

Ben Shelock


People also ask

How do I convert time to Unix timestamp in Excel?

Select a blank cell, suppose Cell C2, and type this formula =(C2-DATE(1970,1,1))*86400 into it and press Enter key, if you need, you can apply a range with this formula by dragging the autofill handle. Now a range of date cells have been converted to Unix timestamps.

How is Unix timestamp calculated?

Unix time is a way of representing a timestamp by representing the time as the number of seconds since January 1st, 1970 at 00:00:00 UTC.


2 Answers

If you just need a good date-parsing function, I would look at date.js. It will take just about any date string you can throw at it, and return you a JavaScript Date object.

Once you have a Date object, you can call its getTime() method, which will give you milliseconds since January 1, 1970. Just divide that result by 1000 to get the unix timestamp value.

In code, just include date.js, then:

var unixtime = Date.parse("24-Nov-2009 17:57:35").getTime()/1000 
like image 64
Ian Clelland Avatar answered Nov 01 '22 23:11

Ian Clelland


Seems like getTime is not function on above answer.

Date.parse(currentDate)/1000 
like image 36
chovy Avatar answered Nov 01 '22 23:11

chovy