[RESOLVED] UNIX Timestampt

[crazy_fool]

Hello.
when i type

echo time();

it will print out something like 1199924812
how can i convert that into something like the actually time?
Thanks

[NogDog]

[man]date/man

[crazy_fool]

i no date function, i mean on forums there time is saved as that, but i want to convert it so when i create an outside page i will be able to display e.g when the post was sent.

[NogDog]

date() takes an optional 2nd parameter, which is any UNIX timestamp integer value.

[crazy_fool]

erm, well could you please give an example of the code please

[crazy_fool]

does any1 know how to put this into a short script, the first post shoudln't of been that because that is confusing the fact that it is already stored into the database and i want to get it from there to convert to readable time and date.
Thanks

[NogDog]

The simplest solution is to extract it from the database in the desired format. If using MySQL, use the DATE_FORMAT() to format it, e.g.:

SELECT *, DATE_FORMAT(timestamp_field, '%Y-%m-%d') AS date_ymd FROM table_name

If that is not practical for some reason, then if, in fact, the value you are getting from the database is a UNIX timestamp integer, then as I suggested above, you just supply that value as the second parameter to date():

echo date('Y-m-d', $timestamp_value_from_db);

[crazy_fool]

Wow thanks, thats great 🙂