<div>
Hi,<br />
DATETIME datatype holds a whole date like 1/1/2008 not just the year.<br />
<br />
Gary
</div>


Hi,
DATETIME datatype holds a whole date like 1/1/2008 not just the year.

Gary

<div>
Hi tbsgadi,<br />
<br />
Yes DateTime datatype holds a whole date and I want to update just the year in it.<br />
<br />
For eg: If I have a date &quot;01/15/2003&quot; <br />
I want to update it to &quot;01/15/2008&quot;<br />
<br />
Any options please.<br />
<br />
Thanks
</div>


Hi tbsgadi,

Yes DateTime datatype holds a whole date and I want to update just the year in it.

For eg: If I have a date "01/15/2003"
I want to update it to "01/15/2008"

Any options please.

Thanks

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have this Date Field in my table in DATETIME datatype and I would like to update the year with 2008 of the entire table.<br />
I tried this but it did not work<br />
Update Productivity<br />
&nbsp;set RecCreateDate=&quot;2008&quot;<br />
where RecCreateDate is not null<br />
<br />
It gave an Error.<br />
Could you please give me a correct SQL statement for this<br />

</div>
</div>


Hi,

I have this Date Field in my table in DATETIME datatype and I would like to update the year with 2008 of the entire table.
I tried this but it did not work
Update Productivity
 set RecCreateDate="2008"
where RecCreateDate is not null

It gave an Error.
Could you please give me a correct SQL statement for this


Update Year of Datefield column with 2008 in MS SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.