alibaba / alibaba/Alibaba-Java-Coding-Guidelines

Guide about date

未关闭
#26 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
没有语言数据
星标
1.1k
派生
246
PR 合并指标
30 天内没有已合并 PR

描述

According to

```
9. [Mandatory] A table must include three columns as following: id, gmt_create and gmt_modified.

Note: id is the primary key, which is unsigned bigint and self-incrementing with step length of 1. The type of gmt_create and gmt_modified should be DATETIME.

```

Can I understand that in Alibaba it is recommended to define the date type as DATETIME? If not, shall we add guide about this? TIMESTAMP or DATETIME is the right choice?

We see that it is mandatory to define gmt_create, gmt_modified, can we understand that when dealing with cross time zone issues you recommend storing the date of gmt time in the database and then converting it to local time zone for display?

贡献指南

这个仓库没有索引到贡献指南

调研方向

issue 中没有指出文件或测试。首先确定指南应推荐 DATETIME 还是 TIMESTAMP,以及应如何跨时区处理 UTC 值;当指南包含明确的推荐和时区指导时,即表示完成。

由索引模型根据 Issue 内容生成。

评估

技术栈
sql
领域
databases, documentation
Issue 类型
文档
难度
4/5
预计耗时
3-5 天
活跃度
停滞
描述清晰度
需要澄清
新手友好度
25/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。