SQL NOW() Function
NOW ( ) Function provides you the current date and time according to your computer's system date and time.
The SQL syntax for the Now ( ) function is:
Now ( )
The Now function returns a date and time that are stored in system.
Understand with Example
The Tutorial helps you to illustrate a example from SQL NOW( ) Function. In this Tutorial, we create a table 'Stu_Table' using create statement.
Insert Data into Stu_Table
The insert into statement is used to add records or rows into the table 'Stu_Table'.
SQL statement to insert data into table:
Records in the table:
In this example, the use of Now function is used to returns the current date and time according to your computer's date and time. The Now( ) function return you the current date and time in double precision .
The Select now ( ) provide the current date and time.