SQL Date Functions Cheat

SQL Date Functions Cheat Sheet

Below are some commonly used SQL date functions along with examples:

        
            -- 1. CURRENT_DATE()
            SELECT CURRENT_DATE() AS CurrentDate;
            -- Output: 2023-07-24

            -- 2. NOW() / CURRENT_TIMESTAMP()
            SELECT NOW() AS CurrentDateTime;
            -- Output: 2023-07-24 15:30:45

            -- 3. DATE()
            SELECT DATE(OrderDate) AS OrderDateOnly
            FROM Orders;
            -- Output:
            -- OrderDateOnly
            -- 2021-09-15
            -- 2021-09-16
            -- 2021-09-17

            -- 4. EXTRACT() / DATE_PART()
            SELECT EXTRACT(YEAR FROM OrderDate) AS OrderYear,
                   EXTRACT(MONTH FROM OrderDate) AS OrderMonth,
                   EXTRACT(DAY FROM OrderDate) AS OrderDay
            FROM Orders;
            -- Output:
            -- OrderYear  |  OrderMonth  |  OrderDay
            -- 2021       |  9           |  15
            -- 2021       |  9           |  16
            -- 2021       |  9           |  17

            -- 5. DATE_ADD() / DATE_SUB()
            SELECT DATE_ADD(OrderDate, INTERVAL 2 DAY) AS NewDate
            FROM Orders;
            -- Output:
            -- NewDate
            -- 2021-09-17
            -- 2021-09-18
            -- 2021-09-19

            -- 6. DATEDIFF()
            SELECT DATEDIFF('2021-09-17', '2021-09-15') AS DateDiff;
            -- Output: 2

            -- 7. DATE_FORMAT()
            SELECT DATE_FORMAT(OrderDate, '%Y-%m-%d') AS FormattedDate
            FROM Orders;
            -- Output:
            -- FormattedDate
            -- 2021-09-15
            -- 2021-09-16
            -- 2021-09-17

            -- 8. MONTHNAME()
            SELECT MONTHNAME(OrderDate) AS MonthName
            FROM Orders;
            -- Output:
            -- MonthName
            -- September
            -- September
            -- September

            -- 9. DAYNAME()
            SELECT DAYNAME(OrderDate) AS DayName
            FROM Orders;
            -- Output:
            -- DayName
            -- Wednesday
            -- Thursday
            -- Friday

            -- Add more SQL date functions and examples as needed