SELECT SYSDATE FROM DUAL

SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1

SELECT TODAY FROM TABLE

SELECT GETDATE() FROM TABLE

mysql> select now();  
mysql> select sysdate();  
mysql> select curdate();  
mysql> select current_date;  
mysql> select curtime();  
mysql> select current_time;

select DATE() from TABLE