Wrong time in Database

[Kratoswoo]

So our server is located in Cali and we are 2 hours ahead so When I save my time to database it does it according to the local time.

I tried to figure out how to use GetDate() and GetUTCDate() but can not figure out how to use it.

How do I make it so when I log in here it saves as this local time and not the databases local time?

Any help would be appriciative

Thanks

[cereal]

Those functions are not for MySQL, you have to use CONVERT_TZ(): https://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_convert-tz

You can also change the database time zone, for example:

SET GLOBAL time_zone = 'UTC';

http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html

[imBaCodes]

USE NOW() ..