Last Month Faced an Issue on one of MySQL DB Server. System Date was showing wrong while System time was correct. I compared both time like below:
In application MySQL was throwing wrong date, after digging I run below query which I fond from fortrabbit.com
SELECT @@global.time_zone, @@session.time_zone;
India Standard Time
Finally I found Time Zone of Windows System Time was china and MySQL time was still Indian Standard Time and previously windows system time was changed without re-starting MySQL Services so it was showing Indian Standard time.
Issue resolved just Re-starting MySQL Server Service..