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