mysql-date函数

INSERT INTO tb_user(user_id, user_name, event_day) VALUES(1001, "zhaoshuai01", NOW() ); # 2022-05-15 10:27:40
INSERT INTO tb_user(user_id, user_name, event_day) VALUES(1002, "zhaoshuai02", CURDATE() ); # 2022-05-15
INSERT INTO tb_user(user_id, user_name, event_day) VALUES(1003, "zhaoshuai03", CURTIME() ); # 10:29:49
INSERT INTO tb_user(user_id, user_name, event_day) VALUES(1004, "zhaoshuai04", DATE(NOW())); # 2022-05-15
INSERT INTO tb_user(user_id, user_name, event_day) VALUES(1005, "zhaoshuai05", DATE(CURTIME())); # 2022-05-15

Date显示格式：YYYY-MM-DD；DateTime显示格式：YYYY-MM-DD HH:mm:ss。

建表语句：

CREATE TABLE `tb_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `user_name` varchar(255) NOT NULL COMMENT '用户名字',
  `event_day` date NOT NULL COMMENT '日期',
  PRIMARY KEY (`id`),
  KEY `event_day` (`event_day`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;