11. Date & Time Functions

This module helps you work safely with temporal data across filtering, reporting, and interval calculations.

Lessons

• Current Date and Time Functions
• Formatting and Parsing Dates
• Date Arithmetic and Difference

Function Selection Table

Need	Function family
Current timestamp	NOW(), CURRENT_TIMESTAMP
Output formatting	DATE_FORMAT()
Parsing string to date	STR_TO_DATE()
Add/subtract intervals	DATE_ADD(), DATE_SUB()
Difference between dates	DATEDIFF(), TIMESTAMPDIFF()

What's Next

• Continue to 12. Views