Post
Ask Question

Many Ways to Get the Current Time.

There are 8 ways to get the current time:


mysql>SELECT NOW() FROM DUAL;

date-time-1.gif

mysql>SELECT CURRENT_TIME() FROM DUAL;

date-time-2.gif

mysql>SELECT SYSDATE() FROM DUAL;

date-time-3.gif

mysql>SELECT CURRENT_TIMESTAMP() FROM DUAL;

date-time-4.gif

mysql>SELECT LOCALTIME() FROM DUAL;

date-time-5.gif

mysql>SELECT LOCALTIMESTAMP() FROM DUAL;

date-time-6.gif

mysql>SELECT UTC_TIME() FROM DUAL;

date-time-7.gif

mysql>SELECT UTC_TIMESTAMP() FROM DUAL;

date-time-8.gif