| http://www.chinaunix.net 作者:CCBZZP??發表于：2003-09-30 11:31:08 |
| 【發表評論】【查看原文】【DB2討論區】【關閉】 |
取當前日期各種數據庫的寫法?
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.?SQLSERVER?
SELECT?GETDATE()?FROM?TABLE?
6.?MYSQL?
mysql>;?select?now();?
mysql>;?select?sysdate();?
mysql>;?select?curdate();?
mysql>;?select?current_date;?
mysql>;?select?curtime();?
mysql>;?select?current_time;?
7.?FOXPRO?
select?DATE()?from?TABLE
歡迎大家補充! |
|
|