数据库中取当前日期的各种方法

1. oracle select sysdate from dual
2. db2 select current timestamp from sysibm.sysdummy1
3. informix select today from table
4. sqlserver select getdate() from table
5. mysql mysql> select now();

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

6. max db sysdate
7. sybase getdate()
8. openbase sysdate
10. foxpro select date() from table