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
Telegram: DB developers channel