(DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds

Database
Teradata Employee

(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 .

5 REPLIES
Enthusiast

Re: (DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds

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

Teradata Employee

Re: (DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds

Thanks Raja :)

Teradata Employee

Re: (DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds

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 ?

Enthusiast

Re: (DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds

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

Teradata Employee

Re: (DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds

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