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...
分享到:
相关推荐
IANA Time Zone Database (简称tzdata) 时区数据
如何修改时区(TIMEZONE)如何修改时区(TIMEZONE)如何修改时区(TIMEZONE)如何修改时区(TIMEZONE)
世界范围内的时区列表。由 java.util.TimeZone 类导出
php报时区错误,按照网上说的改时间date.timezone... You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still
前端项目-timezone-js,JavaScript timezone library based on Olson timezone data
api-ms-win-core-timezone-l1-1-0.dll
TimeZone例子TimeZone例子TimeZone例子TimeZone例子
最新Google日历的时区选择列表Time zone,2021年9月2日
今天说一下时钟和日历里的Home time zone显示不一致的问题,大家一起学习下。
Delphi 无控件实现TimeZone世界时间对照程序 Delphi无控件实现TimeZone世界时间对照程序,选中一个时间,可显示世界主要城市对照时间,方便倒时差。
IDEA连接mysql报时区serverTimezone错误 解决方案
前端项目-moment-timezone,分析并显示任何时区中的时刻。
Arduino-Timezone.zip,Arduino图书馆,方便时区转换和自动夏令时(夏季)调整。Arduino时区图书馆,Arduino是一家开源软硬件公司和制造商社区。Arduino始于21世纪初,深受电子制造商的欢迎,Arduino通过开源系统提供...
NULL 博文链接:https://bchen.iteye.com/blog/1632845
mysql关于时区的插件,解决django集成celery时的报错
TimeZoneNames, 使用CLDR和TZDB源提供本地化时区名称 TimeZoneNames 使用CLDR和TZDB源提供本地化时区名称的简单库。为什么因为. NET's 通常的时区显示名称没有正确地本地化,并且不适合各种方案。 阅读这里博客文章...
PostgreSQL的学习心得和知识总结(四十五)|关于PostgreSQL数据库开源作业调度扩展 pg_cron 默认GMT时区修改 的实现方案
要求经过测试: Ubuntu 16.04 LTS Ubuntu 18.04 LTS Ubuntu 20.04 LTS 应该与: 所有Ubuntu 所有Debian角色变量 ag_timezone : A timezone (e.g Etc/UTC)依存关系没有任何。剧本范例 - hosts : servers roles : - { ...
可以查看不同地区timezone的工具,非常方便易用
timezone,linux下安装kettle时所需的依赖包,解决libwebkitgtk报错问题