时间类型字段自动创建或者更新支持毫秒 #1867

New Issue

roger777luo · 2021-02-12T02:47:43Z

roger777luo commented

2021-02-12 02:47:43 +00:00

支持格式化话携带毫秒

![image](/attachments/402d18bc-6235-4b88-8095-2ad8c1bdf600) 支持格式化话携带毫秒

image.png

90 KiB

image.png

383 KiB

lunny added the

kind

proposal

label 2021-06-12 07:27:39 +00:00

seven1240 commented

2021-06-14 03:25:29 +00:00

+1，这个在每秒写入数据很多时有用。

mysql 可以用DATETIME(3)

  `created_at` DATETIME(3) DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',

reverse 后

	CreatedAt  time.Time `xorm:"created"`

+1，这个在每秒写入数据很多时有用。 mysql 可以用`DATETIME(3)` ``` `created_at` DATETIME(3) DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间', ``` reverse 后 ``` CreatedAt time.Time `xorm:"created"` ```

lunny commented

2021-06-14 09:13:19 +00:00

We should have a new tag to indicate this column have a datetime with millisecond. If DATETIME(3) is expected which is different from Datetime, it's good to me. But for other database, we also have timestampz. Or we can support both.

We should have a new tag to indicate this column have a datetime with `millisecond`. If `DATETIME(3)` is expected which is different from `Datetime`, it's good to me. But for other database, we also have `timestampz`. Or we can support both.

seven1240 commented

2021-06-27 01:29:25 +00:00

PostgreSQL also has TIMESTAMP(n)

PostgreSQL also has `TIMESTAMP(n)`

lunny added this to the 1.2.1 milestone 2021-08-04 08:11:35 +00:00

lunny referenced a pull request that will close this issue

2021-08-04 08:12:05 +00:00

Fix timesatmp #2021

lunny closed this issue

2021-08-04 08:12:12 +00:00

Sign in to join this conversation.