SQL – NOW()

Prev     Next

SQL NOW() function is used to return system’s current date & time. Syntax for SQL NOW() function is given below.

SQL Syntax for NOW() function:

Syntax for NOW() function in SQL

SELECT NOW() FROM table_name;

Please consider the following table with few records as given below.

Table name (for example): student
Column names in this table: Student_ID, Student_name, City and Marks
Available records: 4 rows