SQL NOW() Function

The NOW() Function

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

SELECT NOW() FROM table_name

We have the following "Products" table:

Prod_Id	ProductName	Unit	UnitPrice
1	Safari	1000 g	10.45
2	Kisan	1000 g	32.56
3	Burger	1000 g	15.67

Now we want to display the products and prices per today's date.

We use the following SELECT statement:

SELECT ProductName, UnitPrice, Now() as PerDate FROM Products

The result-set will look like this:

SQL HOME
SQL Syntax
SQL Select
SQL Distinct
SQL Where
SQL And & Or
SQL Order By
SQL Insert
SQL Update

SQL Functions
SQL avg()
SQL count()
SQL first()
SQL last()
SQL max()
SQL min()
SQL sum()
SQL Group By
SQL Having
SQL ucase()
SQL lcase()
SQL mid()
SQL len()
SQL round()
SQL now()
SQL format()