CURRENT_DATE & CURRENT_TIMESTAMP

How do we capture current system date and timestamps in queries?

Intermediate⏱ 3 Minutes⭐ 520 XP

🤔 THE QUESTION

How do we capture current system date and timestamps in queries?

💡 WHAT IS IT?

CURRENT_DATE returns the current date, and CURRENT_TIMESTAMP returns the current date and time.

🎯 WHAT IS IT USED FOR?

Audit columns (created_at, updated_at), real-time reporting, calculating dynamic day offsets.

💻 EXAMPLE

SELECT
CURRENT_DATE AS today,
CURRENT_TIMESTAMP AS current_time;

Practice typing production-grade SQL code for CURRENT_DATE & CURRENT_TIMESTAMP.