I have a column in my table of type datetime
. I want to display them in a particular format, so I tried using this:
echo date( 'm/d/Y - g:h A', strtotime($dateFromMySQL) );
...which just messes everything up, completely.
If I simply do echo $dateFromMySQL;
(in a loop), I get this:
2011-09-10 01:03:04
2011-09-10 00:52:47
2011-09-10 00:40:26
and so on...
...which is correct.
If I do echo strtotime($dateFromMySQL);
, I get this:
1315630984
1315630367
1315629626
and so on...
...which might be correct. I wouldn't know.
However, when I do echo date( 'm/d/Y - g:h:s A', strtotime($dateFromMySQL) );
, I get this:
09/10/2011 - 1:01:04 AM
09/10/2011 - 12:12:47 AM
09/10/2011 - 12:12:26 AM
and so on...
...which is obviously wrong.
So, my question is, what am I doing wrong?
Am I somehow not using strtotime
and date
correctly?