Get the current date and time

sql

SELECT NOW(), CURRENT_DATE(), CURRENT_TIME();

Explanation

Useful for diagnostics, defaults, and test queries.

Learn the surrounding workflow

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

Same sheet · prioritizing date and time functions

Calculate a future date or time.

Open In sheetsqlsame section

Calculate a relative date in the past.

Open In sheetsqlsame section

Render a datetime using format specifiers.

Open In sheetsqlsame section

Calculate age or duration.

Open In sheetsqlsame section

Read a path inside a JSON document.

Write or replace a value inside a JSON document.