System Date

[NZ_Kiwis]

My web server is based in another country, when I convert a time stamp it's several hours ahead of me. So when I do this I can get the wrong day, how can I correct this?

$query_auto = "INSERT INTO dateplayground (dp_name, dp_date)
	VALUE ('DATE: Auto CURDATE()', CURDATE() )";

[dagon]

run

SET time_zone = timezone;

before your query

9.7. MySQL Server Time Zone Support