ORACLE
select sysdate from dual
ORACLE 9
select systimestamp from dual
SQLSERVER
The current_timestamp is more accurate, but only known to be supported in SQL Server 7.0 and later
select getdate();
select current_timestamp
MYSQL
select now()
POSTGRES 8
select now()
POSTGRES PLUS
select sysdate
HANA
select current_timestamp from dummy
INGRES 9
select current_timestamp
INFORMIX
select distinct current timestamp from informix.systables
HSQL
call current_timestamp"
H2
call current_timestamp()
DB2
values current timestamp
CUBRID
select now()
No comments:
Post a Comment