数据库常识---获取系统时间

ORACLE
SELECT SYSDATE FROM DUAL

SYBASE ANYWHERE
SELECT GETDATE()

DB2
SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1

INFORMIX
SELECT TODAY FROM TABLE

SQLSERVER
SELECT GETDATE() FROM TABLE

MYSQL
mysql> select now();
mysql> select sysdate();
mysql> select curdate();
mysql> select current_date;
mysql> select curtime();
mysql> select current_time;

Max DB
SYSDATE

openbase
SYSDATE

FOXPRO
SELECT DATE() FROM TABLE