MySQL time

Can I set MySQL time to IST?

If yes how?

The MySQL time zone is linked to the system time zone, so it’s not possible to change it without changing the time zone for all databases.

However, you can override the PHP timezone using the date_default_timezone_set function.

null

Can you please tell the difference of system time and IST.

@Admin said:
The MySQL time zone is linked to the system time zone, so it’s not possible to change it without changing the time zone for all databases.

However, you can override the PHP timezone using the date_default_timezone_set function.

Can you please tell the difference of system time & IST

@NamarsahaM_Document_Manager said:

@Admin said:
The MySQL time zone is linked to the system time zone, so it’s not possible to change it without changing the time zone for all databases.

However, you can override the PHP timezone using the date_default_timezone_set function.

Can you please tell the difference of system time & IST

The system timezone is “America/New_York” I believe.