Current Date and Time in SQL

Level 113 keystrokes

NOW returns the current date and time, so the result differs on every run.

SQL code

-- NOW returns the current date and time of the database server
-- The value changes on every run; MySQL shows it as YYYY-MM-DD HH:MM:SS
1SELECT NOW();

Output

+---------------------+
| NOW()               |
+---------------------+
| 2024-03-15 10:30:00 |
+---------------------+
1 row in set
Practice typing this code

Practice typing this code. Results are not recorded in the rankings.

Symbols in this code

The symbols you type in this SQL code and how often they appear.

  • ;× 1
  • (× 1
  • )× 1

More SQL examples at level 1

← SQL typing practice