Retrieve time() stored in db

[expert_21]

Hi, here's an example:

ID Time
-- ----
1 1073417668
2 1073468590

The column Time is based on time() function. So how can i retrieve the info stored in Time to a more readable format, like the date (eg. 06.01.2004). Thank you.

[dcrombie]

Use the PHP date [php.net] function.

[coopster]

An example:

print date("d.m.Y", 1073417668);