Time dont show right

[Asuka]

I got a database with a time saved it in
like this
Date Time Title
2004-04-28(DATE) 14:30(TIME) Something(char(250))
this is how I saved the data in the database
put then I pull out the data it shows up like this
date Time Title
2004-04-28 14:30:00 SOmething
I need a way to auto remove the last :00 then I take out the dates

Hope someone can help me, becures it would be a dam lot of work to change everything I have done so far, about 4 weeks of work

😉

[remnant]

date_format

[Asuka]

Well I tryed to find it on the link you send but it didnt help me much, I just need a easy way to save a time only with hour:min format

[Asuka]

sorry