How to round timestamp?

[CapsuleCorpJX]

SELECT average(Query_E_Timestamp - Query_B_Timestamp SECOND(4)) as "Average
FROM dbtest.dbtesttable

Apparently the average returned by the query is very precise, with up to 6 digits right of the decimal.

Anyway, what is a function that can round it to X.Y seconds?

Is there a special way to use CAST(<data> as Format '<format string'>)?

 

[BillDHS]

Off hand I would say to cast it as Decimal(x+y, y). You could also try removing the (4) from the calculation which indicates 4 decimals.

 

[dnoeth]

You just specify it: SECOND(4,2)

But remember that the maximum of 9999 seconds is less than 3 hours, so maybe you have to use "hour to second"...

Dieter