Print Page - Remove Time values from the date time datatype column

Title: Remove Time values from the date time datatype column
Post by: saumil287 on 14 Jun 2011 01:21:25 AM

Hi All,
I am having a column containing date time values as Mar 31, 2009 12:00:00 AM, the column data type is Date time in fm.
The source is ms sql server 2005
How to remove the time value from the above mentoined column i.e I want only Mar 31, 2009.
I tried from fm using the format type but not able to get the things done.
Any help is appreciated
Thanks in Advance

Title: Re: Remove Time values from the date time datatype column
Post by: hthakkar on 14 Jun 2011 06:13:27 AM

Hi,

You can try out the following possibilities:
1.Try changing the format from Date Time to Date.
2.Use , Cast ()as date
3.Use Substring to trim the characters and just trim the Date part from it.

Thanks,
Hitesh
----------------------------------------------------------
hthakkar@infocepts.com|www.infocepts.com
----------------------------------------------------------

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: saumil287 on 14 Jun 2011 01:21:25 AM