Which function is used to check current date and time in SQL?

Programming Language
#1

NOW() function is used to check the current date and time value. The return type for NOW() function is either in ‘YYYY-MM-DD HH:MM:SS’ format or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context.

Syntax :

NOW()

Parameter : This method does not accept any parameter.

Returns : It returns the current date and time value.

Example: Finding the current date and time using NOW Function. Here we will get the result in ‘YYYY-MM-DD HH:MM:SS’ format.

SELECT NOW() as CurrDateTime ;

Output :

CURRDATETIME

2020-11-26 18:37:42