Page 105 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 2 : Using DATE Functions:

1 NOW() – Current date and time
SELECT NOW();
-- Result: Current date and time
2 DATE FORMAT() – Format a date

SELECT DATE FORMAT(NOW(), ‘%Y-%m-%d’);
-- Result: Formatted date (YYYY-MM-DD)

90
CITS : IT & ITES - Computer Software Application - Exercise 28 CITS : IT & ITES - Computer Software Application - Exercise 28