Conversion int to Datetime
Posted on 2009-07-09
Hi expert, hope that someone help me to find a solution to this problem.
I'm developing COGNOS BI based on SQL 2000 database,the BI Application must produce report about Hour of job of one employee , and other information.
In one table i stored the minute (datatype=INT) so 480minute are 8hour, or 7153 it's equal to 119hour and 13 minutes..On the Cognos side when i create repor of aggregate data , i have some trouble because the calculation give me error of non compatibilty datatype because the data coming out from sql server as char this because i want format the data in this way:
So my question is what is the best datataype to store correctly the number of hour
ex: 08:30 .and what kind of trasformation i will do to have the possibility of calculate the TOTAL of hour trought COGNOS FRAMWORK