Re: l2datetime stored procedure needed
Milen Metodiev wrote:
>
> I would like to have a sorted list of users by connection time. In
> syssessions table there is a 'connected' column which is the one I need.
I use
select ...,extend(date("1970/01/01"),year to second) + connected units second
from syssessions
order by ...
It is very slow however. Comments anyone?
--
/* ----------------------------------------------------- *
* Willem Roos wroos@shoprite.co.za *
* roosj@mweb.co.za *
* 0(+27)21 980 4941 *
* 0(+27)21 919 0198 *
* ----------------------------------------------------- */