Tesco: Date Function

Full Name

Email ID

Which statement correctly finds the number of days between two dates in MySQL?

• SELECT DAYS_BETWEEN(date1, date2);

• SELECT DATE_SUB(date1, date2);

• SELECT DATEDIFF(date1, date2);

• SELECT DATE_DIFFERENCE(date1, date2);

If you want to retrieve all sales transactions that happened in the first quarter (Jan-Mar), which query should you use?

• SELECT * FROM Sales WHERE MONTH(Date) IN (1, 2, 3);

• SELECT * FROM Sales WHERE QUARTER(Date) = 1;

• SELECT * FROM Sales WHERE EXTRACT(QUARTER FROM Date) = 1;

• All of the above

How do you retrieve the year and month from a column named order_date?

• SELECT YEAR(order_date), MONTH(order_date) FROM orders;

• SELECT EXTRACT(YEAR FROM order_date), EXTRACT(MONTH FROM order_date) FROM orders;

• Both

• None of the above

Your company wants to find employees who joined this year. The employees table has a column hire_date (DATE format). Which query correctly retrieves employees who joined in the current year?

• SELECT * FROM employees WHERE YEAR(hire_date) = CURRENT_DATE;

• SELECT * FROM employees WHERE YEAR(hire_date) = YEAR(CURRENT_DATE());

• SELECT * FROM employees WHERE hire_date = GETDATE();

• SELECT * FROM employees WHERE DATE_PART('year', hire_date) = NOW();

A banking system needs to find out the age of customers based on their birth_date. Which SQL query correctly calculates the age?

• SELECT TIMESTAMPDIFF(YEAR, birth_date, CURDATE()) AS age FROM customers;

• SELECT birth_date - CURRENT_DATE AS age FROM customers;

• SELECT DATEDIFF(birth_date, CURDATE(), YEAR) / 365 AS age FROM customers;

Your company is sending birthday discounts to customers whose birthdays fall in the current month. Which query is correct?

• SELECT * FROM customers WHERE MONTH(birth_date) = MONTH(NOW());

• SELECT * FROM customers WHERE DATE_PART('month', birth_date) = CURRENT_DATE();

• SELECT * FROM customers WHERE EXTRACT(MONTH FROM birth_date) IN EXTRACT(MONTH FROM NOW());

• None