Solved

datetimeoffset datatype

Posted on 2010-09-08
1
342 Views
Last Modified: 2012-05-10
hi experts, i am reading about datetimeoffset datatype
http://msdn.microsoft.com/es-es/library/bb630289.aspx
http://msdn.microsoft.com/en-us/library/ms186724.aspx
but not enough
I need an example like that hand on lab
0
Comment
Question by:enrique_aeo
1 Comment
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 200 total points
ID: 33632514
enrique_aeo,

Which part is unclear?

If it is the concept of the data type itself, the datetimeoffset type is a means of storing a date and time value with awareness of its timezone.  Instead of simply being stored in the timezone of the server, the datetimeoffset field allows you to specify the exact timezone for which the date and time represents.

e.g., 2010-09-08 19:46:00 -04:00

That represents my current time.

The value specified by the size determines the precision of the datatype.  7 for example specifies that you can have up to 7 decimal places (fractional seconds).

Hope that helps.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now