UNIX_TIMESTAMP taken from MySQL and converted to Date in JS gives weird result

Question

PHP

Hello.

SELECT FROM_UNIXTIME(1342382400)

In mysql gives 2012-07-16 00:00:00
But

var date = new Date(1342382400*1000);
console.log(date)

Shows Sun Jul 15 2012 23:00:00 GMT+0300

Maybe I missed something and did not take into account time zones / locale?

Answer 1

Most likely yes, time zones, the difference is only one hour.
MySQL works in the time zone of the server, and JS in the time zone of the browser, that is, the client computer.
Apparently the server is running at GMT+0400

Answer 2

Yes, the difference in time zones is equal to one hour.

FROM_UNIXTIME() functions return values ​​in the connection's current time zone

Answer 3

Store on the server in UTC, and on the client:
var timezoneDate = new Date();
var timezoneOffset = timezoneDate.getTimezoneOffset();
var date = new Date((1342382400 - (timezoneOffset * 60)) * 1000);
console log(date);
From the timestamp in seconds, subtract the timezone shift (in minutes * 60) in seconds, then multiply by the mower and make happiness :)