dates

mysql_query

print "$row->date<br>";

This prints out something like "021002"

How can I format it nicely, like Oct 02, 2002.

This is gotten out of a database with a TIMESPAMP value.

Thanks.

examancer

this should work:

$f_date = date("F j, Y, g:i a", $row['date']);

check out http://www.php.net/manual/en/function.date.php for more info on how to change the format the date is displayed in. If the time source is not a correct UNIX timestamp, then you will need to change the code like this:

$f_date = date("F j, Y, g:i a", strtotime($row['date']));

mysql_query

Thanks, but...

The first code gives me a date of December 31, 1969 and the second code gives today's date. Why does this happen?

examancer

that can't be a timestamp then. could you give some examples of what format the date is in? And, is that a MySQL database? MySQL timestamps aren't normally malformed. Are you putting the timestamps into the database manually?

mysql_query

Hello. Yes, I'm using a MySQL database. The coulmn date, that is TIMESTAMP is set on 6 didgits and is NULL, therefore it puts the date in automatically in format YYMMDD. So in the script, I get something like 021012, which is not easy to read.

Thanks.

sijis

yep, I know what you mean.
You get a goofy date when using the date(); function and stuff.
It took me a while, but this should work for your needs.

I'm also very sure you were using timestamp.

Enough, here's the code:

$date = date("m/j/y",time($string));

sijis

the weird thing, is that i only found 1 reference to that when i have having the same problem.

mysql_query

The problem with this is, it still gives me today's date, not the date in the database. Little help?

Thanks.

sijis

first off i hope you are able to get any data from the db.
if you can, store the date in a $var, the format it,
like so.

try this:

$date = date("m/j/y",time($row['date']));

or

$date_from_db = "$row['date']"; 
// or is it $date_from_db = "$row->date";
// i'm not familiar with $row->foo though.

$formatted_date = date("m/j/y",time($date_from_db));

echo $formatted_date;