judy judy - 26 days ago 7
MySQL Question

MySql: unchangeable timezone

my hosting provider is Godaddy My server location is in Europe and It is in the Amsterdam time zone. support team says :


"As this is a s\hared hosting platform you would be able to get the
time zone which is installed in parent server.you cannot change it" .


i want to show Australian timezone.
php.ini
is not provided. both mysql
Timestamp
and
PHP
function date() showing wrong time.

Answer Source

PHP:

http://php.net/manual/en/function.date-default-timezone-set.php

ini_set('date.timezone', 'Australia/Australian');

I'm not sure about: Australia/Australian You can update it :)

MySQL:

https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html