The SQL NOW () function obtains the data of the current day.

The SQL NOW () function obtains the data of the current day.

In the NOW () function
Return the current system date and time in the NOW () function.

Current SQL () syntax

SELECT NOW() FROM table_name

 
 

  
  
 
   
 
    
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 product and price every today's date.

We use the following SELECT statement:
 
SELECT ProductName, UnitPrice, Now() as PerDate FROM Persons
Output result.
 
  
  

   
   
 
    
 
     
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