Heya heres a (hopefully) easy one,
how can I convert this DATETIME value:
2014-01-16 12:00:00
to an unix timestamp via JavaScript or JQuery?
In PHP It is easy but in JavaScript it seems hard. I found out that Date.parse() or new Date() provide me that but this only helps with timestamps containing this other format with day of the week.
Is there a way to convert this 'numeric' variant aswell?
Thanks in advance~
Heya heres a (hopefully) easy one,
how can I convert this DATETIME value:
2014-01-16 12:00:00
to an unix timestamp via JavaScript or JQuery?
In PHP It is easy but in JavaScript it seems hard. I found out that Date.parse() or new Date() provide me that but this only helps with timestamps containing this other format with day of the week.
Is there a way to convert this 'numeric' variant aswell?
Thanks in advance~
Share Improve this question asked Jan 10, 2014 at 8:47 SteiniSteini 2,78317 silver badges24 bronze badges4 Answers
Reset to default 12In order to convert this string to a Javascript date format, you need to replace the space character between date and time with the character T in order to create a valid ISO8601 format. Then you can use .getTime() for the unix timestamp of this date.
var timestamp = new Date('2014-01-16 12:00:00'.replace(' ', 'T')).getTime();
You could do this, but note 2014-01-16 12:00:00 is the local time of the machine.
var ts = new Date('2014-01-16 12:00:00').getTime() / 1000;
Update:
As @devnull69 said, Firefox only accepts the ISO format, you have to replace the space to T.
Date.prototype.getTime returns a unix timestamp in milliseconds. If you want it in seconds, divide it by 1000.
function mysql_to_unix(date) {
return Math.floor(new Date(date).getTime() / 1000);
}
mysql_to_unix("2014-01-16 12:00:00"); // returns 1389870000
<script>
function test(date){
n=date;
var d=new Date(n).getTime() / 1000
console.log(d);
}
</script>
<body onLoad="test('2014-01-16 12:00:00')">
</body>