Display in format hh:mm:ss

Issue Description

We have a table in which we have value stored in seconds. But On report we need to display it in format hh:mm:ss. Formula has to work on both sql server and Oracle

Resolution

To use one function with different database you need to add it to WEB-INF/applicationContext-semanticLayer.xml for each database To oracleSQLGenerator bean "to_char(to_date(" + sqlArgs[0] + ", 'SSSSS'),'HH24:MI:SS')" To bean sqlserverGenerator "convert(varchar,dateadd(ss, "+ sqlArgs[0] + ", 0),8)" As function returns different type then we need to add it also in applicationContext-el.xml and restart server. Then you can use sec2time() function in domain designer.