lundi 20 juillet 2015

How to convert datetime column to datetimeoffset in SQL Server 2005

I have a query which selects customer details from a table. That table contains a Created_Time column as datetime datatype. While selecting, I want to cast this column to datetimeoffset in SQL Server 2005.

Query:

select 
    Cust_ID, SubTitle, Summary, PreOrdered, Created_Time -- this column
from 
    Cust_Summary_PreOrder_Info

I want to achieve this SQL Server 2005.

Aucun commentaire:

Enregistrer un commentaire