date formatting oddness

Anon

I am storing a date formatted as below into a mysql datetime data source.

$intdate = date("Y-m-d h:I:s");

the dates appear as 2001-11-06 04:20:53 in the database.

I print the date out through the sql query like so:

SELECT this, that, theotherthing, DATE_FORMAT(datefield, '%W, %b %e, %Y %H:%i %p') AS datePosted FROM table WHERE blah blah blah...

For some reason the dates are printing out as AM instead of PM.

Any ideas are appreciated

yendor

I believe your problem is here.

$intdate = date("Y-m-d h:I:s");

should be

$intdate = date("Y-m-d h:i:s");

I don't think capital I is a valid date Format Code. Lowercase i however is the date Format Code for minutes. Also in your DATE_FORMAT function you are returning %H for the hours which I believe is the MySQL Format Code from hours in 24-hour form not 12-hour form. If all else fails you could just use MySQL to input the current date/time into your database. Just replace your $intdate variable with NOW() in your MySQL INSERT query.