扫码加入数据分析学习群

select date('220101');

select date('22-01-01 12:34:56');

select year('220101');

select year('22-01-01 12:34:56');

select month('220101');

select month('22-01-01 12:34:56');

select day('220101');

select day('22-01-01 12:34:56');

select hour('12:34:56');

select hour('22-01-01 12:34:56');

select date_add("2020-01-01",interval 2 month);

select date_sub("2022-01-01", interval 1 day);

select date_sub("2022-01-01 12:34:56", interval 1 minute);

select date_format('2012-01-01','2022-%m-%d');

select curdate();

select curtime();

select now();

select timestampdiff(month,'2020-01-01','2020-03-22');

select unix_timestamp();

select unix_timestamp('2022-01-01');

select from_unixtime(1640966400);