Date Functions in SQL

Certainly! SQL (Structured Query Language) provides various date functions that allow you to work with date and time data in your database. Here are some common date functions in SQL:

1. **CURRENT_DATE**: Returns the current date.
```
SELECT CURRENT_DATE;
```

2. **CURRENT_TIME**: Returns the current time.
```
SELECT CURRENT_TIME;
```

3. **CURRENT_TIMESTAMP**: Returns the current date and time.
```
SELECT CURRENT_TIMESTAMP;
```

4. **DATEPART() / EXTRACT()**: Extracts specific components (e.g., year, month, day) from a date.
```
SELECT DATEPART(YEAR, your_date_column) AS Year FROM your_table;
```

5. **DATEADD()**: Adds or subtracts a specified interval to/from a date.
```
SELECT DATEADD(DAY, 7, your_date_column) AS NewDate FROM your_table;
```

6. **DATEDIFF()**: Calculates the difference between two dates.
```
SELECT DATEDIFF(DAY, start_date, end_date) AS DaysDifference FROM your_table;
```

7. **DATE_FORMAT() / TO_CHAR() / CONVERT()**: Formats a date as a string.
```
SELECT DATE_FORMAT(your_date_column, '%Y-%m-%d') AS FormattedDate FROM your_table;
```

8. **CAST()**: Converts one data type to another, useful for converting strings to dates and vice versa.
```
SELECT CAST(your_string_date AS DATE) AS DateValue FROM your_table;
```

9. **MONTH() / DAY() / YEAR()**: Extracts specific parts of a date directly.
```
SELECT MONTH(your_date_column) AS Month FROM your_table;
```

10. **SYSDATE()**: Returns the current date and time in some database systems.

These functions can vary slightly between different database systems (e.g., MySQL, PostgreSQL, SQL Server), so be sure to consult your database's documentation for specific usage in your environment.