How many ways to get the current time ?

SELECT NOW() FROM DUAL;

2006-07-01 10:02:41

SELECT CURRENT_TIME() FROM DUAL;

10:02:58

SELECT SYSDATE() FROM DUAL;

2006-07-01 10:03:21

SELECT CURRENT_TIMESTAMP() FROM DUAL;

2006-07-01 10:04:03

SELECT LOCALTIME() FROM DUAL;

2006-07-01 10:07:37

SELECT LOCALTIMESTAMP() FROM DUAL;

2006-07-01 10:08:08

SELECT UTC_TIME() FROM DUAL;

14:09:22

SELECT UTC_TIMESTAMP() FROM DUAL;

2006-07-01 14:09:49