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

核心提示：数据库中取当前日期的各种方法 1. Oracle SELECT SYSDATE FROM DUAL 2. DB2 SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1 3. INFORMIX SELECT TODAY FROM TABLE 4. SQLS

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

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