Currently I'm using this line of code
echo date("F j Y g:i:s", $row[date]);
But it just gives me January 1 1970 2:33:31
I also want it to look normal because if I don't do the date("F j Y g:i:s", at all, all I get is 2011-03-02 23:00:30 which is the correct date, but displayed in a very abnormal way
Typecast to UNIX_TIMESTAMP inside the query:
SELECT UNIX_TIMESTAMP(YourDateField) FROM YourTable
Since I see responses to the other answer while this is ignored, let me elaborate:
There are two common date types. Both are actually numbers, that represent a duration since a given date.
If you got the first date, but treat it like the second format, you arecounting days for seconds. Instead of 111 years since 1900, you're counting 111 seconds since 1970. That explains why you get that date.
Therefore, use the UNIX_TIMESTAMP function, which will convert the first float notation to a timestamp in seconds. It is needed because that is also the type PHP uses.
You probably need to use strtotime, the date functions expects the 2nd parameter to be a unix timestamp
date("F j Y g:i:s", strtotime($row[date]));
If you want different formatting you can take a look at this page: Date formatting
You might want something like this:
date("Y-m-d H:i:s", strtotime($row[date]));
php > print date("F j Y g:i:s",strtotime('2011-03-02 23:00:30')); > March 2 2011 11:00:30 As you see above strtotime is what you need. Just make sure $row['date'] returns the correct value. Use var_dump($row['data']) to see what is value and type of your variale