Remove Time values from the date time datatype column

[saumil287]

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

[hthakkar]

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
----------------------------------------------------------