<div>
CallDate is already datetime! you want to remove time part?<br />
do you want to convert it to date only? and put time part into Calltime?<br />
do you have values in CallTime now? or is it empty...<br />
<br />
\can you give a sample and tell us what are you trying to do here...<br />

</div>


CallDate is already datetime! you want to remove time part?
do you want to convert it to date only? and put time part into Calltime?
do you have values in CallTime now? or is it empty...

\can you give a sample and tell us what are you trying to do here...


<div>
I don't want to involve the Time column. <br />
I was looking for a data type to cut the Datetime field down. <br />
Is there a way to Alter Column?
</div>


I don't want to involve the Time column.
I was looking for a data type to cut the Datetime field down.
Is there a way to Alter Column?

<div>
use alter column<br />
<br />
ALTER TABLE TABLENAME<br />
ALTER COLUMN CALLDATE DATE
</div>


use alter column

ALTER TABLE TABLENAME
ALTER COLUMN CALLDATE DATE

<div>
<div class="content wysiwyg-content">
I have a very large table [MasterFinal] and it includes a column that has a datetime type named CallDate<br />
There is also a Calltime field so I would like to Alter the CallDate to type Date like 01/01/2011<br />
Can someone help me?
</div>
</div>


I have a very large table [MasterFinal] and it includes a column that has a datetime type named CallDate
There is also a Calltime field so I would like to Alter the CallDate to type Date like 01/01/2011
Can someone help me?

SQL Server 2008 Problems altering data type to Date

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.