<div>
Thanks. But in given link datetimeoffset is converted into UTC format. But I would like to perform from datetime field. <br />
<br />
Say for example below is my format:<br />
<br />
declare @createdon DateTime<br />
set @createdon = '2013-03-08 12:35:41.807'<br />
<br />
<br />
I would like to get UTC in datetimeoffset (2) format. Please assist.
</div>


<div>
<pre><code id="code-20-39329682-1"> CAST(CONVERT(datetime, 
SWITCHOFFSET(CONVERT(datetimeoffset, 
CreatedDtm), 
REPLACE(DATENAME(TzOffset, SYSDATETIMEOFFSET()),'+','-') )) AS datetimeoffset)</code></pre>
<br />
Above code solved the issue.
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
&nbsp; In my table tPostTran there was a column called PostedDtm. The data type of it was DateTime. Now the DB is being upgraded. The posteddtm column's data type is modified as DateTimeOffset(2). The column already contained data. I would like to modify the existing date value to UTC format. How to achieve this?<br />
<br />
&nbsp; What is the difference between datetime and datetimeoffset (2)?
</div>
</div>


Hi Experts,

  In my table tPostTran there was a column called PostedDtm. The data type of it was DateTime. Now the DB is being upgraded. The posteddtm column's data type is modified as DateTimeOffset(2). The column already contained data. I would like to modify the existing date value to UTC format. How to achieve this?

  What is the difference between datetime and datetimeoffset (2)?

Thanks. But in given link datetimeoffset is converted into UTC format. But I would like to perform from datetime field. 

Say for example below is my format:

declare @createdon DateTime
set @createdon = &#39;2013-03-08 12:35:41.807&#39;


I would like to get UTC in datetimeoffset (2) format. Please assist.

How to convert existing datetime into UTC format?

Hi Experts,

  In my table tPostTran there was a column called PostedDtm. The data type of it was DateTime. Now the DB is being upgraded. The posteddtm column&#39;s data type is modified as DateTimeOffset(2). The column already contained data. I would like to modify the existing date value to UTC format. How to achieve this?

  What is the difference between datetime and datetimeoffset (2)?

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.