SQLize Online / PHPize Online  /  SQLtest Online

create table tbl_customer( cust_id int auto_increment primary key not null, cust_name varchar(100), cust_registered_date date, cust_credit_limit decimal(12,2) ); INSERT INTO tbl_customer(cust_name, cust_registered_date, cust_credit_limit) VALUES ('JOHN', '2024-02-15', 5000), ('JAMES', '2024-02-15', 6000), ('JANA', '2013-07-11', 4000), ('SHEILA', '1998-11-30', 7000), ('JOSEPH', '1999-08-27', 10000); --select cust_name, date_add(cust_registered_date, INTERVAL 10 day) from tbl_customer; select datediff(MONTH(curdate()), MONTH(cust_registered_date) ) from tbl_customer; SELECT cust_name, DATEDIFF(MONTH, cust_registered_date, CURDATE()) AS months_since_registration; SELECT cust_name, PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM CURDATE()), EXTRACT(YEAR_MONTH FROM cust_registered_date)) AS months_since_registration FROM tbl_customer; SELECT MONTH(curdate()) as 'Month', DAY(curdate()) as 'Day'; SELECT EXTRACT(month from curdate()), EXTRACT(day from curdate()); select date_add(utc_time(), interval 7 hour); SELECT ROUND(cust_credit_limit, 3) FROM tbl_customer; select IFNULL(cust_name, 'unknown') from tbl_customer