CREATE TABLE `student_table` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` char(10) DEFAULT NULL, `created_time` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `index_created_time` (`created_time`) ) ENGINE=InnoDB
SELECT * FROM student_table WHERE created_time < '2022-01-01' ;
SELECT * FROM student_table WHERE created_time <= '2021-12-31' ;
SELECT * FROM student_table WHERE substr(created_time,1,10) < '2022';
SELECT * FROM student_table WHERE created_time < '2022-01-01 00:00:00' ;
SELECT * FROM student_table WHERE created_time < substr('2020-02-11 22:06:17',1,10);
扫描二维码，关注牛客网
下载牛客APP，随时随地刷题
扫一扫，把题目装进口袋
扫描二维码，进入QQ群
扫描二维码，关注牛客公众号
京公网安备
11010502036488号
