How do you read a date?

[cmdr_bond]

I know this is a stupid question but I was wondering how you can read a date/time field out of a table. Now I know how to run a mysql query, but how do you display it in pretty format?

I tried: date("F j, Y, g:i a",$myrow[date]); but it doesnt do the job; rather, it displays some random date in 1969.

What am I doing incorrectly?

[drew010]

the second paramater of the date paramater accepts a unix timestamp. im guessing the myrow['date'] is an actual english date format. try using strtotime($myrow['date']) in the parameter to get more reasonable results.

[chris_davies]

how did you set the date? was it with date() or datetime(), either way you can extract the date with:

date_format(time, '%b %e %Y')as fmt_time

where time should be what your actual date attribute is called, this will bring out the date like: Apr 20 2005

%b is the abbreviated month, %e is the date and %Y (capital Y) for 2005, use a small y for a 2 digit year

hope this helps
Chris