Incorrect Modified Time in Mysql

The time reported in the backend for the modfied time is different from time recorded in Mysql.



In mysql i hour time difference



but server time is correct


Comments

  • Looks like this s joomla thing date stored in UTC format.
  • Hi,

    That's correct. All dates and times before being saved to database are converted to Greenwich time (GMT), which is a good and very common practice.
    When time is displayed on the other hand, Joomla! uses server's configured timezone (offset) and adjusts the time on the fly. That's why you see the difference.
Sign In or Register to comment.