How can I convert a Sql Server 2008 DateTimeOffset to a DateTime

by

Converting using almost any style will cause the datetime2 value to be converted to UTC.
Also, conversion from datetime2 to datetimeoffset simply sets the offset at +00:00, per the below, so it is a quick way to convert from Datetimeoffset(offset!=0) to Datetimeoffset(+00:00)

declare @createdon datetimeoffset
set @createdon = '2008-12-19 17:30:09.1234567 +11:00'

select CONVERT(datetime2, @createdon, 1)
--Output: 2008-12-19 06:30:09.12

select convert(datetimeoffset,CONVERT(datetime2, @createdon, 1))
--Output: 2008-12-19 06:30:09.1234567 +00:00

More Related Contents:

  1. How can I select the first day of a month in SQL?
  2. Efficiently convert rows to columns in sql server
  3. How can I get column names from a table in SQL Server?
  4. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  5. Multi-statement Table Valued Function vs Inline Table Valued Function
  6. SQL Server Insert if not exists
  7. Select statement to find duplicates on certain fields
  8. How to set table name in dynamic SQL query?
  9. Using a Variable in OPENROWSET Query
  10. How to find current transaction level?
  11. How do I see active SQL Server connections?
  12. Check for file exists or not in sql server?
  13. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  14. Group DateTime into 5,15,30 and 60 minute intervals
  15. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  16. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  17. How can I compare time in SQL Server?
  18. Which SQL query is faster? Filter on Join criteria or Where clause?
  19. How to compare datetime with only date in SQL Server
  20. SQL Server SELECT LAST N Rows
  21. How can I group by date time column without taking time into consideration
  22. The transaction log for the database is full
  23. Generate random int value from 3 to 6
  24. Add emoji / emoticon to SQL Server table
  25. What is the internal representation of datetime in sql server?
  26. Select SQL Server database size
  27. Backup a single table with its data from a database in sql server 2008
  28. COALESCE Function in TSQL
  29. Try_Convert for SQL Server 2008 R2
  30. SQL SERVER DATETIME FORMAT

Leave a Comment