ORACLE SELECT SYSDATE FROM DUAL
SYBASE ANYWHERESELECT GETDATE()
DB2 SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1
INFORMIX SELECT TODAY FROM TABLE
SQLSERVER SELECT GETDATE() FROM TABLE
MYSQL mysql> select now(); mysql> select sysdate(); mysql> select curdate(); mysql> select current_date; mysql> select curtime(); mysql> select current_time;
Max DB SYSDATE
openbase SYSDATE
FOXPRO SELECT DATE() FROM TABLE
转载于:https://www.cnblogs.com/lzx_ok/archive/2011/06/30/2094870.html
