[Resolved] date/time conversion

[TravisB]

I am getting the time a page is visited by using the time() function. When I read the time from the database I am getting data like 1054684812. I think I should use the date() funtion to convert this into something more readable, but I am having trouble using it.

[laserlight]

Well, you can read the PHP manual on how to use date()

Exactly how are you having trouble using date() ?

[TravisB]

Well, of course I went to the manual first and then looked around on here for a while and did not find a solution. Basically, I have something like this

while ($row = @ mysql_fetch_array($rs)) {
$time1 = $row["entry_time"];
$time2 = date(l,time1);
echo $time2; 
}

$time2 gives me Wednesday, which I know is wrong because the day I took it from is Tuesday. I think it is outputting today, Wednesday.

[RedDragon]

im using this solution

$formatted = gmdate('D, d M Y', $stamp);

[kevinsequeira]

how is the date stored in the database, what is the datatype you are using - date, datetime, varchar, timestamp ???

reg
kevin

[TravisB]

First I get the time visited using time() and store it in a database as an integer. Then I want to be able to read that time and format however I want.

[TravisB]

Thanks RedDragon, your solution works.