0

CURDATE(), now(), sysdate() all of them are showing yesterdays date which is causing to show wrong results in the system.

Below is the screenshot for the query in MySQL and its result query and result

Can someone indicate as to why this is happening?

Fard
  • 3
  • 4
  • Query reports MySQL server's datetime whereas the tray provides client's datetime. – Akina Jan 13 '21 at 06:13
  • 1
    Does this answer your question? [How do I set the time zone of MySQL?](https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql) – kmoser Jan 13 '21 at 06:14
  • Query returns the time of the MySQL server. The server might be running in different timezone. – Santosh Jan 13 '21 at 06:20

1 Answers1

0

Check for the MySql server date time settings, as query is returning server`s date time.

Abilogos
  • 4,777
  • 2
  • 19
  • 39
Ratna Priya
  • 26
  • 1
  • 4