Loading

Many Ways to Get the Current Time.

Arjun Panwar

15y8.8k1025Blog

1 Comment

Join the conversation! Your thoughts help the community grow.

Subash10y ago
Nice info

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;