📄️ 11. Date and Time Functions
Work with PostgreSQL dates, timestamps, intervals, and time zone conversions.
📄️ Current Date and Time Functions
Use PostgreSQL current date/time functions correctly (now(), CURRENT_DATE, CURRENT_TIMESTAMP, clock_timestamp()) and handle time zones safely. Focus: Current Date and Time Functions.
📄️ Formatting and Parsing Dates
Format timestamps for output with to_char(), parse text safely with to_date()/to_timestamp(), and avoid timezone and casting traps in PostgreSQL. Focus: Formatting and Parsing Dates.
📄️ Date Arithmetic and Difference
Add/subtract intervals, compute differences between dates and timestamps, and bucket time safely in PostgreSQL. Focus: Date Arithmetic and Difference.