RE: Is it a bug in datetime function HOUR (now()-date_created) ?

2002-04-07 Thread Roger Baklund
* Son Nguyen mysql select date_created from forums; +-+ | date_created| +-+ | 2002-04-04 19:27:03 | +-+ 1 row in set (0.00 sec) mysql SELECT CONCAT(HOUR(now()-date_created), 'H', MINUTE(now()-date_created), 'M',

Is it a bug in datetime function HOUR (now()-date_created) ?

2002-04-06 Thread Son Nguyen
mysql select date_created from forums; +-+ | date_created| +-+ | 2002-04-04 19:27:03 | +-+ 1 row in set (0.00 sec) mysql SELECT CONCAT(HOUR(now()-date_created), 'H', MINUTE(now()-date_created), 'M', SECOND(now()-date_created),