Many Ways to Get the Current Time.

Arjun Panwar
13y
5.2k
0
0
25
Blog

There are 8 ways to get the current time:

mysql>SELECT NOW() FROM DUAL;



mysql>SELECT CURRENT_TIME() FROM DUAL;



mysql>SELECT SYSDATE() FROM DUAL;



mysql>SELECT CURRENT_TIMESTAMP() FROM DUAL;



mysql>SELECT LOCALTIME() FROM DUAL;



mysql>SELECT LOCALTIMESTAMP() FROM DUAL;



mysql>SELECT UTC_TIME() FROM DUAL;



mysql>SELECT UTC_TIMESTAMP() FROM DUAL;