time question

Anon

if i have time stored as a unix timestamp (Time()) how do i convert this to something readable?

Thanks!

Anon

use the date() function

check out this URL:
http://www.php.net/manual/en/function.date.php

-Jim Keller
http://www.centerfuse.net

Anon

no i already have the date in unix timestamp form stored in a MySQL database. i need to convert it to standard time!

jim_keller

Exactly. You can use:

date("g:i A", $row["timestamp"]);

this will print the time in a format like: 4:00 PM
it's a little strange that a function called date() also displays time of day, but it is a very versatile function that will let you display the time any way you please.

I hope this is what you were asking.

-Jim Keller
http://www.centerfuse.net

Anon

or you could use strftime. check out all the different options you can for mat it with at http://www.php.net/strftime

It's very flexible and might be what you're looking for.

~~Stezz

[deleted]

Here is some ugly code:

function epoch($sqldatetime)
{
$hour = substr($sqldatetime,11,2);
$minute = substr($sqldatetime,14,2);
$second = substr($sqldatetime,17,2);
$month = substr($sqldatetime,5,2);
$day = substr($sqldatetime,8,2);
$year = substr($sqldatetime,0,4);
return mktime($hour, $minute, $second,
$month, $day, $year);
}

$nicetime = strftime(\"%x\", epoch($datetime));
print (\"The nice time is $nicetime\");

[deleted]

ugh I didn't add those backsladhes. Remove them!