數(shù)據(jù)庫中取當(dāng)前日期的各種方法

數(shù)據(jù)庫中取當(dāng)前日期的各種方法
    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