Re: [PHP-DB] Working with "time" data from MYSQL

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/