6.4 日期时间函数
select curdate();
select current_date();
select curtime();
select current_time();
select now();
select sysdate();
select date_add(date,interval expr type);
select date_add('2022-07-01',interval 5 month);
select datediff('2017-02-01','2017-01-01');
select date_format('2017-04-01','%Y%m')
日期计算使用案例:
insert into borrowinfo value(20150301,'210210199901013333',curdate(),date_add(curdate(),interval 1 month),'否');
SELECT * FROM borrowinfo;
SELECT * FROM bookinfo WHERE book_id = 20150301;
UPDATE bookinfo SET store = store -1 WHERE book_id = 20150301;
SELECT * FROM readerinfo;
SELECT * FROM bookinfo WHERE book_id = 20150301;
UPDATE readerinfo SET balance = balance -69*0.05 WHERE card_id = '210210199901013333';
SELECT book_id,book_category_id,book_name,author,price,press,DATE_FORMAT(pubdate,'%Y%m'),store FROM booinfo;
SELECT * FROM bookinfo;
SELECT book_id,book_category_id,book_name,author,price,press,DATE_FORMAT(pubdate,'%Y-%m'),store FROM bookinfo;