SQL NOW() Function

The NOW() Function

The NOW() function returns the current system date and time.

SQL NOW() Syntax

SELECT NOW() FROM table_name;

Example

SELECT ProductName, Price, Now() AS PerDate
FROM Products;