RE: [PHP-DB] timestamp problem
| From: | John W. Holmes | Date: | Fri, 14 Mar 2003 01:50:25 +0000 |
| Subject: | RE: [PHP-DB] timestamp problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26368@lists.php.net to get a copy of this message | ||
> 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/