Which function in SQL is used to return current date as well as time?

Programming Language
#1

CURRENT_TIMESTAMP() function server is used to return the current date as well as time. And the format of the output is as follows.

'YYYY-MM-DD hh:mm:ss.mmm'

Features :

  • This function is used to find the current date and time.
  • This function comes under Date Functions.
  • This function doesn’t accept any parameter.
  • This function can also be used as a default value in some codes.

Syntax :

CURRENT_TIMESTAMP

Parameter :

This method doesn’t accept any parameter.

Returns :

It returns the current date as well as time and the format of the output returned is ‘YYYY-MM-DD hh:mm:ss.mmm’.