Easy question on date() function format

[moriax]

I want to save date in a mySQL table of type "datetime". I do so by adding by php:
date("Y-m-d H:i");
As you can se I dont want the seconds, only hours and minutes. But when displaying the saved data from the database the seconds are still written out, but only as 00.
Example: "2005-05-10 23:27:00"

I dont now what I'm doing wrong. If the problem is with the database type or with the php code?

So how do I add time without seconds to the database or how do I fetch time without seconds from the database? I prefer the easiest way :-)

[mtmosier]

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

Look for DATE_FORMAT.

[moriax]

Thanx mtmosier, I guess your tip works just fine but I stumbled upon another solution to do this with php which suits me better:

<?php
date("d M Y H:i", strtotime($your_row['date']));
?>