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: > I’m 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 it’s 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 Email Away" > Kevin Campbell > Chief Executive Officer > The Club Mix, Inc. > http://www.theclubmix.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
