Cheat Sheet logoCheat Sheet Today
SQL Functions and Aggregation/Get current date and timestamp

Return the current date and current timestamp.

Back to sheetBrowse commands
Sign in to save
Section: Date and Time Functions

Get current date and timestamp

sql
sql
SELECT CURRENT_DATE AS today, CURRENT_TIMESTAMP AS now_ts;
Explanation

These values are useful for auditing and reporting queries.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Date and Time Functions
Extract date parts
Return year, month, day, and other pieces from a date or timestamp.
OpenIn sheetsqlsame section
Add an interval
Shift a date or timestamp forward or backward.
OpenIn sheetsqlsame section
Cast timestamp to date
Remove the time portion from a timestamp.
OpenIn sheetsqlsame section
Aggregate by date
Roll up metrics by calendar day.
OpenIn sheetsql1 tag match
Concatenate strings
Join multiple strings into one value.
OpenIn sheetsql
Use CASE expression
Return different values based on conditions.
OpenIn sheetsql