Re: Working with "time" data from MYSQL
| From: | Chris | Date: | Thu, 05 Jun 2008 01:38:34 +0000 |
| Subject: | Re: Working with "time" data from MYSQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45044@lists.php.net to get a copy of this message | ||
Sebastian Hofferberth wrote:
> Hi
>
> I have a MYSQL/PHP question for which I do not find an answer on the web.
>
> I have a MySQL table with a column of datatype "time". What I want to do is
> read the values from this table but display the database entries plus 6
> hours. For example, when the database entry is 12:00:00, I want to display
> 18:00:00 on my website.
>
> I tried all kinds of tricks, with strtotime() in PHP and UNIX_TIMESTAMP() in
> MySQL, but I simply cannot figure it out.
Probably easiest with a native mysql function:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_addtime
--
Postgresql & php tutorials
http://www.designmagick.com/