mysql NOW() function

UK[naʊ] US[naʊ]

adv. now; at that time; immediately; (to attract the other person’s attention before changing the topic or asking the other party to do something) Hello

adj.Now of; present; present

n.now; currently; currently

conj.because;since

mysql NOW() function syntax

Function: Return the current date and time.

Syntax: SELECT NOW() FROM table_name

Notes: If you are using Sql Server database, please use getdate() Function to get the current date and time.

mysql NOW() function example

//显示当天的日期所对应的名称和价格。
SELECT ProductName, UnitPrice, Now() as PerDate FROM Products;