date is not presented correctly

Question

I insert my date with the Now() mysql function, and when I select the date I use this:

DATE_FORMAT(com.date,'%h:%i  %d/%m/%Y ')

Basically, the output that I get is the same, no matter what time I enter the input (The date is correct, but the time is incorrect):

12:00 20/11/2011

How can I correct this?!?

Answer 1

Mysql set current timestamp when you use now() function. So it should be correct output when you query by SELECT DATE_FORMAT(com.date,'%h:%i %d/%m/%Y ')

I assume your com.date column is a timestamp, not a date.