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 |
The Altova MissionKit is an integrated suite of tools ideal for:
- XML development
- Web & Web services development
- Data mapping & integration
- Rendering & publishing XML & database data
- XBRL validation, taxonomy editing, transformation & rendering
The MissionKit for XML Developers includes XMLSpy® - the industry-leading XML editor; MapForce® - a
graphical data mapping, conversion, and integration tool; StyleVision® - a visual XSLT stylesheet designer;
DiffDog® - an XML-aware diff/merge tool; and 2 additional tools.
Try all 6 products free for 30 days!
Download a fully-functional free trial
|
|
|
|
