> If I do "select CURRENT_TIMESTAMP-USER_LOGIN FROM TIME_TABLE" I get
> the result in days (I think so). But no way to convert it to seconds.
> I tried to divide result by 3600 but is always 0!

If you multiply the 'days' result by 86400 (number of seconds in a day)
you will get the number of seconds.


Sean