Timezone

How stupid I was yesterday.... :
The first time I saw such kind of datatime format: "2012-07-09T00:00:00-06:00".

And I researched in wikipedia, found something.

引用

If greater precision is desirable to represent the time interval, then more time elements can be added to the representation. An observation period that has a duration of approximately three days, for example, can be succinctly shown as "2007-11-13/15", i.e. from any time on 2007-11-13 to any time on 2007-11-15. If a more exact start and end of the observation period need to be shown either for clarity or for measurement and recording purposes, the same time interval representation could be expanded to "2007-11-13T00:00/15T24:00", i.e. midnight at the start (T00:00) of 2007-11-13 to midnight at the end (T24:00) of 2007-11-15, a total of 72 hours.

And I was so careless to go through that and thought the format mentioned above describes a time period... and told the client manager this may be a data issue in another team, we need talk with them to determine what's the final format we need to display...

Until the scrum meeting this morning, another colleague told me that suffix "-06:00" means UTC-06 timezone...

OMG, how shame is it...