Text only
|
Text with Images
COGNOiSe.com - The IBM Cognos Community
IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: esanray on 24 Nov 2011 11:51:21 PM
Title:
Numeric to time format
Post by:
esanray
on
24 Nov 2011 11:51:21 PM
Numeric to time format
1500 to 15:00
Title:
Re: Numeric to time format
Post by:
HalfBloodPrince
on
25 Nov 2011 12:21:27 AM
First convert time column it to varchar using cast( [Time], varchar(10)) then
create new calculation as new time as cast(substring([Text Time],1,2)+':'+substring([Text Time],3,4)+':00',time)
thanks,
Text only
|
Text with Images