| http://www.chinaunix.net 作者:CCBZZP??發(fā)表于：2003-09-30 11:31:08 |
| 【發(fā)表評論】【查看原文】【DB2討論區(qū)】【關(guān)閉】 |
取當(dāng)前日期各種數(shù)據(jù)庫的寫法?
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
歡迎大家補充! |
|
|