Oracle,mysql,sqlserver three databases How to get the current time of the system

How to get the system current time in Oracle: With Sysdate ()

The current time to get the system in MySQL mainly has the following points:

(1) the Now () function returns the current datetime with (' Yyyy-mm-dd HH:mm:SS ') and can be stored directly in the DateTime field

(2) the Curdate () function returns today's date in the format ' Yyyy-mm-dd ', which can be stored directly in the Date field

(3) The Curtime () function returns the current time in the format ' HH:mm:SS ', which can be stored directly in the Date field

A very powerful date formatting function in SQL Server :

Get current system time, GETDATE ();

Oracle,mysql,sqlserver three databases How to get the current time of the system