SQL
Date & Time Functions
Work with dates and timestamps.
By TechCoder TeamLast updated: 2026-06-02
In a Nutshell
Work with dates and timestamps. This hands-on tutorial focuses on practical implementation of date & time functions concepts.
Date & Time in SQL
Handling dates varies significantly between database systems. Here we focus on standard SQLite date functions supported in this playground.
| Function | Description |
|---|---|
DATE() | Returns the date part of a timestamp. |
TIME() | Returns the time part. |
DATETIME() | Returns date and time. |
STRFTIME() | Formats a date/time. |
Example: Current Date and Time
Example: Date Math
Find the date 7 days from now.