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> 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