All Forums Database
Sandeepyadav 52 posts Joined 09/13
10 Dec 2014
(DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds

Hi All,
 
just want to conver the elapsedtime (H:MM:SS.00) to Seconds. DBC.Qrylog has one column Elapsedtime but i want this value in seconds only.
 
Please suggest .

Thanks, -Sandeep.
Raja_KT 1246 posts Joined 07/09
10 Dec 2014

There may be better ways. However, I am thinking this way:
SELECT EXTRACT (hour FROM '13:36:15.5') *3600 a,EXTRACT (minute FROM '13:36:15.5') *60 b, EXTRACT (second FROM '13:36:15.5') c, a+b+c

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Sandeepyadav 52 posts Joined 09/13
11 Dec 2014

Thanks Raja :)

Thanks, -Sandeep.

Sandeepyadav 52 posts Joined 09/13
11 Dec 2014

Raja,
 
I Have one more doubt. Can we restrict users to create a fallback table in system ?
can we restrict fallback table creation at user/database/system level ?

Thanks, -Sandeep.

Raja_KT 1246 posts Joined 07/09
11 Dec 2014

I am not aware of the restriction if there is any in the DBS settings .....

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Sandeepyadav 52 posts Joined 09/13
23 Dec 2014

yes, there is DBS Contraol Internal Group parameter-113.

Thanks, -Sandeep.

You must sign in to leave a comment.