mysql NOW() function
Translation results：
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() functionsyntax
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() functionexample
//显示当天的日期所对应的名称和价格。 SELECT ProductName, UnitPrice, Now() as PerDate FROM Products;