Friday, March 10, 2017

Getting current time stamp from database

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