Hàm

Mô tả

Ví dụ

SELECT ADDDATE('2024-09-01', INTERVAL 5 DAY); 

=> '2024-09-06'

SELECT ADDTIME('12:00:00', '02:30:00'); 

=> '14:30:00'

SELECT CURDATE(); 

=> '2024-09-10'

SELECT CURRENT_DATE(); 

=> '2024-09-10'

SELECT CONVERT_TZ('2024-09-01 12:00:00', 'UTC', 'Asia/Ho_Chi_Minh'); 

=> '2024-09-01 19:00:00'

SELECT CURRENT_TIME(); 

=> '14:30:00'

SELECT CURRENT_TIMESTAMP(); 

=> '2024-09-10 14:30:00'

SELECT CURTIME(); 

=> '14:30:00'

SELECT DATE('2024-09-10 14:30:00'); 

=> '2024-09-10'

SELECT DATEDIFF('2024-09-10', '2024-09-01'); 

=> 9

SELECT DAY('2024-09-10'); 

=> 10

SELECT DATE_ADD('2024-09-01', INTERVAL 5 DAY); 

=> '2024-09-06'

SELECT DATE_SUB('2024-09-10', INTERVAL 5 DAY); 

=> '2024-09-05'

SELECT DAYNAME('2024-09-10'); 

=> 'Tuesday'

SELECT DAYOFMONTH('2024-09-01'); 

=> Hàm sẽ lấy ngày đầu tháng trong SQL là ngày 01.

SELECT DAYOFWEEK('2024-09-10'); 

=> 3

SELECT DAYOFYEAR('2024-09-10'); 

=> 254

SELECT EXTRACT(YEAR FROM '2024-09-10'); 

=> 2024

SELECT FROM_DAYS(738000); 

=> '2023-10-03'

SELECT FROM_UNIXTIME(1672531199); 

=> '2023-01-01 00:59:59'

SELECT HOUR('14:30:00'); 

=> 14

SELECT LAST_DAY('2024-09-10'); 

=> '2024-09-30'

SELECT LOCALTIMESTAMP(); 

=> '2024-09-10 14:30:00'

SELECT LOCALTIME(); 

=> '14:30:00'

SELECT MAKEDATE(2024, 100); 

=> '2024-04-09'

SELECT MAKETIME(14, 30, 0); 

=> '14:30:00'

SELECT NOW();

=> '2024-09-10 14:30:00'

SELECT MICROSECOND('14:30:00.123456'); 

=> 123456

SELECT MINUTE('14:30:00'); 

=> 30

SELECT MONTH('2024-09-10'); 

=> 9

SELECT MONTHNAME('2024-09-10'); 

=> 'September'

SELECT PERIOD_DIFF(202409, 202401); 

=> 8

SELECT PERIOD_ADD(202401, 6); 

=> 202407

SELECT QUARTER('2024-09-10'); 

=> 3

SELECT SECOND('14:30:45'); 

=> 45

SELECT SEC_TO_TIME(3661); 

=> '01:01:01'

SELECT STR_TO_DATE('10-09-2024', '%d-%m-%Y'); 

=> '2024-09-10'

Trừ số ngày từ một ngày nhất định.

SELECT SUBDATE('2024-09-10', INTERVAL 5 DAY); 

=> '2024-09-05'

SELECT SYSDATE(); 

=> '2024-09-10 14:30:00'

SELECT TIME('2024-09-10 14:30:00'); 

=> '14:30:00'

SELECT TIMEDIFF('14:30:00', '12:00:00'); 

=> '02:30:00'

SELECT TIME_FORMAT('14:30:00', '%h:%i %p'); 

=> '02:30 PM'