DATE vs TIMESTAMP data types

Concepts: sqlDateVsTimestamp

Date and Timestamp Literals SQL uses specific syntax to write date and timestamp values directly in queries. Date Literals The ISO 8601 format (YYYY-MM-DD) is universally supported. Always use this format for date literals to avoid ambiguity between American (MM/DD) and European (DD/MM) conventions. Timestamp Literals Comparison Date vs Timestamp Here is a side-by-side comparison of the two core temporal types. Which type would you use to track when users perform actions?