RE: timestamp problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> I'm using the timestamp column type in a database, and the only
problem
> is that it the stamp is three hours prior to the actual post when I
post
> to a remote server.  I'm assuming, since it works fine on my machine,
> that this is because the remote server I am is in a different time
> zone.  Is there any way I can amend my code to account for the time
> difference?

So adjust it. Either add 3 hours to any time you add to the database or
when you pull the time from the database... You can use mktime() in PHP
or DATE_ADD() in (assuming) MySQL. 

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux