Mysql query error unix timestamp

Question

can anybody explain me how this Mysql query result is possible.

select 
sec_to_time(
unix_timestamp('2014-10-26 02:00:00')-
unix_timestamp('2014-10-25 20:00:00')
);

result:

07:00:00

should be:

06:00:00

daylight saving time? It is saturday and sunday...

maskacovnik
– maskacovnik

2015-11-11 05:34:34 +00:00
Commented Nov 11, 2015 at 5:34 — maskacovnik
– maskacovnik, Commented Nov 11, 2015 at 5:34

Abhishek Sharma · Accepted Answer · 2015-11-11 05:42:39Z

2

Use MySQL TIMEDIFF or TIME_TO_SEC like that :-

TIME_TO_SEC(TIMEDIFF('2014-10-26 02:00:00', '2014-10-25 20:00:00'))

edited Nov 11, 2015 at 5:42

answered Nov 11, 2015 at 5:35

Abhishek Sharma

6,6241 gold badge17 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user5549328 Over a year ago

ok. i still can't understand why in this specific date (all sat. and sun.), mysql give me wrong result.

user5175034 Over a year ago

Apparently your server's time zone is not set or is set improperly and you're getting GMT rather than local time. More about that here: stackoverflow.com/questions/930900/…

Collectives™ on Stack Overflow

Mysql query error unix timestamp

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related