CURRENT TIMESTAMP

From SQLZoo
Compatibility
CURRENT_TIMESTAMP
EngineOKAlternative
ingresYes
mysqlYes
oracleYes
postgresYes
sqlserverYes

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP returns the current date and time.

 CURRENT_TIMESTAMP -> '2006-12-31 18:03:44'  
1.
schema:gisq
SELECT CURRENT_TIMESTAMP, whn
  FROM gisq.eclipse
SELECT CURRENT_TIMESTAMP, whn
  FROM eclipse
result

See also