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/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php