1. Oracle
SELECT SYSDATE FROM DUAL
2.DB2数据库
SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1
3. Informix数据库
SELECT TODAY FROM TABLE
4.SQL Server 数据库
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.FOXPRO数据库
select DATE() from TABLE
SELECT SYSDATE FROM DUAL
2.DB2数据库
SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1
3. Informix数据库
SELECT TODAY FROM TABLE
4.SQL Server 数据库
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.FOXPRO数据库
select DATE() from TABLE