Hi
I have a measure column that stores the value in
milliseconds .While returning it from the cube i want to
display it in hh:mm:ss:SSS format

Thanx in advance

If you don't have more than 24 hours worth of milliseconds:

SELECT RIGHT(CONVERT(CHAR(25), DATEADD(ms, <milliseconds>, '19000101'),
121), 14)

--
Jacco Schalkwijk
SQL Server MVP


"Nikhil Sharma" <anonymous (AT) discussions (DOT) microsoft.com> wrote