Replies Back to Article
Convert Timestamp to Readable date/time format
Where's the beef?
June 26, 2003 by Drew Sinjin
Where is the content, the info, the sample, the anything? All I see is a article title.
RE: Where's the beef?
June 27, 2003 by Martha Graham
It is a request. The article is not there (yet).
Martha Graham
DMXzone.com
RE: RE: Where's the beef?
July 20, 2003 by chad mr.
Someone should post an article. SQL Server timestamp seems about as useful to me as SQL Server books online - millions of lines of documentation - none of it useful.
Dont use MX but heres a function that will work
February 1, 2004 by Alex Taylor
function timestamp_to_date(ts)
if ts<>"" and isnumeric(ts) then
ts_temp=ts/1000
timestamp_to_date = (dateadd("s",ts_temp,"01/01/1970 00:00:00"))
end if
end function
if ts<>"" and isnumeric(ts) then
ts_temp=ts/1000
timestamp_to_date = (dateadd("s",ts_temp,"01/01/1970 00:00:00"))
end if
end function
RE: RE: RE: Where's the beef?
March 3, 2004 by liam whleodn
I have found timestamp usefull for making my stats counter for my site,
Counting members active in past 20mins
$result = mysql_query("SELECT * FROM stats
WHERE level = 1
AND visited > NOW() - INTERVAL 20 MINUTE") or die("MySQL members error: ".mysql_error());
$members=mysql_num_rows($result);
and can be used for past 24hours and so-on.