how to interpret this timestamp?
Lets say this is the time-stamp: 2011-07-06T00:00:35.851-07:00
What does that tell me? This is how I am trying to understand it:
2011-07-06 - date
00:00:35 - hh:mm:ss
851 - micro seconds??
07:00 - what does that t开发者_如何学运维ell me?
I need to convert this to UTC if possible with C.
Edit 0: Thanks for the responses by @RichieHindle and @Marc B. I now understand the GMT offset. My problem now is, I am not getting correct value out of getdate.
It says it's July 6th, 2011, 35.851 seconds past midnight, in the GMT-7 time zone. To convert to UTC (GMT-0 timezone), you'd need to add 7 hours (-7 + 7 = 0), making it 2011-07-06T07:00:35.851-00:00
851
is milliseconds (thousandths of a second) and -07:00
is the timezone (UTC minus 7 hours).
精彩评论