Now SQL Tutorial

Now Syntax:

SELECT NOW() FROM my_table

Sales table:

IDPRICENAME
125.845A
226.97B
327.9C
428.34D

Now Example:

SELECT id, price, NOW() as PriceDate FROM store;

Now Result:

IdPricePriceDate
125.84512/9/2012 15:30:23 PM
226.9712/9/2012 15:30:23 PM
327.912/9/2012 15:30:23 PM
428.3412/9/2012 15:30:23 PM