Hi
$query = "INSERT INTO test (email, fullname, registerdate, registertime) VALUES ('$email', '$fullname', current_date, current_time)";
May I ask how can I set current_date and current_time to be GMT?
Thanks
You should save the rows as normal datetime(server time) and If you need some other timezone when getting results, either use PHP or straight from mysql using CONVERT_TZ() function.
DATE: http://uk2.php.net/manual/en/function.date.php
DATE MODIFY: http://uk2.php.net/manual/en/function.date-modify.php
TIMEZONE SET: http://uk2.php.net/manual/en/function.date-timezone-set.php
Im sure one of these can help you. These are all php functions.
