Following is the usage of Date function. Select any of the type that is required. -- Current date and time functions CURRENT_DATE AS current_date, -- Current date in 'YYYY-MM-DD' format CURRENT_TIME ...

Write a query to provide the date for nth occurance of sunday in future from given date -- If today is saturday 2022-01-01 then 1st Sunday is 2022-01-02, 2nd Sunday is 2022-01-09 .. -- 0 = Monday, 1 = ...

SQL also provides various functions for manipulating and extracting date and time values. For example, you can use the CURDATE or NOW functions to get the current date or date and time, respectively.

They are applied in querying, manipulating as well as reporting data and it is commonly used by data analysts, data scientists, and database administrators. This article highlights the different ...