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

文章作者 100test 发表时间 2007:09:15 12:08:09
来源 100Test.Com百考试题网

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> 0select now().

mysql> 0select sysdate().
mysql> 0select curdate().
mysql> 0select current_date.
mysql> 0select curtime().
mysql> 0select current_time.

6. Max DB sysdate
7. Sybase getdate()
8. openbase sysdate
10. FOXPRO 0select DATE() from TABLE