Timestampdiff鍑芥暟鐢ㄤ簬璁＄畻涓や釜鏃ユ湡鎴栨椂闂翠箣闂寸殑宸紓锛屽苟杩斿洖浠ユ寚瀹氬崟浣嶈〃绀虹殑缁撴灉銆傚畠閫氬父涓庡叾浠栧嚱鏁颁竴璧蜂娇鐢紝渚嬪锛?/p>

1. 涓嶯OW()鍑芥暟涓€璧蜂娇鐢紝鍙互璁＄畻褰撳墠鏃ユ湡涓庡彟涓€涓棩鏈熶箣闂寸殑宸紓銆備緥濡傦紝瑕佽绠楀綋鍓嶆棩鏈熶笌2022骞?鏈?鏃ヤ箣闂寸殑澶╂暟宸紓锛屽彲浠ヤ娇鐢ㄤ互涓嬫煡璇細

SELECT TIMESTAMPDIFF(DAY, NOW(), '2022-01-01');

2. 涓嶥ATE_SUB鍑芥暟涓€璧蜂娇鐢紝鍙互璁＄畻涓€涓棩鏈熷噺鍘讳竴娈垫椂闂村悗鐨勬棩鏈熴€備緥濡傦紝瑕佽绠?022骞?鏈?鏃ュ噺鍘?0澶╁悗鐨勬棩鏈燂紝鍙互浣跨敤浠ヤ笅鏌ヨ锛?/li>

SELECT DATE_SUB('2022-01-01', INTERVAL 10 DAY);

3. 涓嶥ATEDIFF鍑芥暟涓€璧蜂娇鐢紝鍙互璁＄畻涓や釜鏃ユ湡涔嬮棿鐨勫ぉ鏁板樊寮傘€備緥濡傦紝瑕佽绠?022骞?鏈?鏃ュ拰2022骞?鏈?0鏃ヤ箣闂寸殑澶╂暟宸紓锛屽彲浠ヤ娇鐢ㄤ互涓嬫煡璇細

SELECT DATEDIFF('2022-01-10', '2022-01-01');

閫氳繃缁撳悎浣跨敤Timestampdiff鍑芥暟鍜屽叾浠栧嚱鏁帮紝鍙互瀹炵幇鏇村鏉傜殑鏃ユ湡鍜屾椂闂磋绠楀姛鑳姐€?/p>