On Saturday 04 August 2001 00:02, Richard Lynch wrote:
> Something like:
>
> select date_format('unix-timestamp', yoursessiontimestampcolumn) from
> sessiontable;
SELECT UNIX_TIMESTAMP(yourtimestampcolumn) AS thetime FROM sessiontable;
could be a bit faster
--
Christian Reiniger
LGDC Webmaster
Something like:
select date_format('unix-timestamp', yoursessiontimestampcolumn) from
sessiontable;
Then, you can just use time() and subtract to get the number of seconds, and
divide by 60 for the minutes.
Or, better yet, you can use MySQL functions to select sessions that are
old/new or whate
2 matches
Mail list logo
