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
Jump to PostThose 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-tzYou can also change the database time zone, for example:
SET GLOBAL time_zone = 'UTC';
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
USE NOW() ..
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.