Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

datetimeoffset datatype

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
enrique_aeo
Asked:
enrique_aeo
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now