Page 105 - Computer Software Application TP - Volume 1
P. 105

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
   100   101   102   103   104   105   106   107   108   109   110