Date and Time Operations Questions

Tests practical skills for working with dates and times in data, reporting, and everyday technical work. Candidates should be comfortable with date and time data types (date vs. timestamp vs. timestamp with time zone) and their storage and comparison semantics, date filtering, relative date ranges such as last-n-days or rolling windows, inclusive versus exclusive range boundaries, timezone conversions and daylight saving time edge cases, business-day and holiday-aware calculations, epoch/unix timestamp conversions, and fiscal or custom period logic. Interviewers assess the ability to translate a reporting or business requirement into correct date logic, choose the right date/time representation for a given system, and reason through common pitfalls such as timezone mismatches between systems and off-by-one boundary errors. This shows up across contexts: SQL queries, spreadsheet formulas, BI tool calculated fields and filters, and date/time handling in general-purpose code.