SQL NOW() Function
The NOW() Function
The NOW() function returns the current system date and time.
SQL NOW() Syntax
| SELECT NOW() FROM table_name |
SQL NOW() Example
We have the following "Products" table:
| Prod_Id |
ProductName |
Unit |
UnitPrice |
| 1 |
Jarlsberg |
1000 g |
10.45 |
| 2 |
Mascarpone |
1000 g |
32.56 |
| 3 |
Gorgonzola |
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:
| ProductName |
UnitPrice |
PerDate |
| Jarlsberg |
10.45 |
10/7/2008 11:25:02 AM |
| Mascarpone |
32.56 |
10/7/2008 11:25:02 AM |
| Gorgonzola |
15.67 |
10/7/2008 11:25:02 AM |
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4000 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
| 
