SQL Now

Now Syntax:

SELECT NOW() FROM my_table

Sales table:

ID	PRICE	NAME
1	25.845	A
2	26.97	B
3	27.9	C
4	28.34	D

Now Example:

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

Now Result:

Id	Price	PriceDate
1	25.845	12/9/2012 15:30:23 PM
2	26.97	12/9/2012 15:30:23 PM
3	27.9	12/9/2012 15:30:23 PM
4	28.34	12/9/2012 15:30:23 PM