My sql datetime

My sql datetime format is 0000-00-00 00:00:00 (2008-11-10 11:56:48)

if $time="2008-11-10 11:56:48";

how can i get "2008-11-10 11:56" (ignore seconds)

help me out
thank you

 

SELECT date(column) as dateonly, DATE_FORMAT(column,'%H : %i')as timewithoutsecs FROM `table`;

 

check this for more examples:

http://www.dan.co.uk/mysql-date-format/

 

If u want to play with PHP functions u can use:

if($time == substr("2008-11-10 11:56:48", 0, -3));