Hello,

I need to get the difference in seconds from system time and login
time in my app. So, when a user log into system I insert 'Now' value
into a timestamp field. But the problem is to get the difference with
actual system time.

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!

Any idea?

Thanks!.