NOW() Function in Sql Server

Introduction:

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

 

Syntax:

SELECT NOW() FROM table_name;

Example:

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