LearningSQL.org
LessonsPlaygroundAbout
Sign In
Lessons/intermediate/Date and Time Functions
PreviousPracticeNext

TL;DR

Master SQL date and time functions to query, format, and calculate temporal data. Extract date parts, compute intervals, and filter by ranges.

Key concepts

  • SQL date functions
  • SQL datetime
  • SQL date formatting
  • SQL date arithmetic

Next lesson

Null Handling

Understand how NULL works in SQL. Learn COALESCE, NULLIF, and IS NULL to write queries that handle missing data correctly.

25 min

Related lessons

  • Aggregation and GroupingLearn to summarize data with aggregate functions like COUNT, SUM, AVG, and GROUP BY
  • SubqueriesLearn to write queries within queries using scalar subqueries, correlated subqueries, EXISTS, and IN
  • Indexes and PerformanceLearn how SQL indexes speed up queries. Create indexes, analyze query plans with EXPLAIN, and optimize database performance.

Also learn

TypeScriptMaster TypeScriptJavaScriptMaster JavaScript ProgrammingRustMaster Rust ProgrammingPHPMaster PHP Web Development

Also learn

TypeScriptMaster TypeScriptJavaScriptMaster JavaScript ProgrammingRustMaster Rust ProgrammingPHPMaster PHP Web Development

A14A

Building digital products that matter.

© 2026 A14A. All rights reserved.
KVK: 87105004PrivacyTerms