I'm fairly certain now() runs off system time...so you can adjust your system
time on the server to reflect your time zone...
if thats not possibly, or not wanted, in place of now, you can use..
DATE_SUB(NOW(), INTERVAL 2 HOUR)
cheers!
On January 7, 2002 11:53 pm, Kevin Campbell wrote:
Brian Snopek writes:
I'm fairly certain now() runs off system time...so you can adjust your system
time on the server to reflect your time zone...
The computer should know what timezone it's in. You can unset TZ
before running safe_mysqld to get MySQL to run on UTC, but that is
a kludge,
Im using the NOW() function to store the date and time in my database table
that a person fills out my form. But I noticed that its 2002-01-07 11:51pm
but the time shows up as 2002-01-08 01:51:18. It appears to be two hours
off. How can I adjust the time to match my time zone?
Always an