Is it possible in Reporting Services 2008 to convert a decimal to a datetime format of HH:MM? I am pulling data from SSAS and in order to get the value of time into the cube as a measure I needed to convert the time to a float and then pass it into the cube. SSAS knows how to conert it by specifiying the format as hh:mm. Unfortunately SSRS seems it is ignoring the format and using the decimal value. Example
0.188194444446708 = 4:31am
SSRS is pulling in the decimal not the formatted time (4:31) like SSAS
anyone know how to convert this to time?
If you do a conversion in T-Sql, like so: select convert(datetime,@t), it will give you this result:
1900-01-01 04:31:00.000 .. Is this something you want? You can do the conversion in T-Sql and format it accordingly in SSRS to get the time. hth.