[RESOLVED] timestamp

[vang]

hi,
how can i retrieve the date(timestamp) from the database and display separately the date and the time.
eg.
Todays date is 2009/05/10
Now the time is 12:33:46

many thanks.

[vang]

select * from table
shows me the data : 2009/05/10 12:33:46
i retrieve the data : $lastlogin = $row["lastlogindate"];
it displays : 2009/05/10 12:33:46
how can i display the date and the time separately?

[NogDog]

You could do it via the query:

SELECT *, DATE(lastlogindate) AS logindate, TIME(lastlogindate) AS logintime FROM table . . .

Alternatively you could do it in the PHP code.

$timestamp = strtotime($row['lastlogindate']);
$date = date('Y/m/d', $timestamp);
$time = date('H:i:s', $timestamp);

[NogDog]

PS: I suppose you could also [man]explode()[/man] the string returned from the query on the space character, but that seems less aesthetically pleasing to me. :rolleyes:

[vang]

now i know where my error is, i missed out this step: strtotime
that's why i could not get the value i want, thanks for your guidance 🙂