How to view the current date in SQL

Methods to view the current date in SQL: Use the CURRENT_DATE function: Return the current system date. Use the GETDATE() function (Microsoft SQL Server only): Returns the current system date. Use NOW() function (MySQL and MariaDB only): Returns the current system date.

How to view the current date in SQL

There are several ways to view the current date in SQL:

Use the CURRENT_DATE function directly:

 <code class="sql">SELECT CURRENT_DATE;</code>

Use the GETDATE() function (Microsoft SQL Server only):

 <code class="sql">SELECT GETDATE();</code>

Use the NOW() function (MySQL and MariaDB only):

 <code class="sql">SELECT NOW();</code>

These functions will return the current system date in YYYY-MM-DD format. For example, if the current date is March 8, 2023, the query result will be:

 <code>2023-03-08</code>

Notice:

• The above function returns the date part, not the time part.
• Different database management systems (DBMS) may support different functions.
• Make sure to use the correct function in the query to match the DBMS you are using.

The above is the detailed content of How to view the current date in SQL. For more information, please follow other related articles on the PHP Chinese website!