各种数据库如何取当前日期和时间?

请问各种数据库是如何取当前日期和时间的?
如DB2,Oracle,sqlserver等。

---------------------------------------------------------------

Oracle:
select sysdate from dual;

SQL Server,Sybase:
select getdate()

---------------------------------------------------------------

一定要给分!
oracle : select sysdate from t_tablename
DB2: Select current date from t_tablename
SQLServer: null

Published At
Categories with 数据库类
comments powered by Disqus