time questions

[Anon]

1) i am pulling it out of the database.. so how do i convert it to a more reconizable format.

[Anon]

hey, i have a couple of questions

1) how do i convert time(); into a reconizable format?

2) how can i select all the records from the database where the time(); is less then 5 days ago?

[reagent]

1) use the date function
2) if using mysql supply this in the where clause:
WHERE date < DATESUB(date, INTERVAL 5 DAY)

p.

[reagent]

you specified that you were using the PHP time() function.

But if you are getting it from the database, look at MySQL's DATE_FORMAT() function

cheers.
p.