CURRENT TIMESTAMP

From SQLZoo
Jump to navigation Jump to search
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'  
schema:gisq
SELECT CURRENT_TIMESTAMP, whn
  FROM gisq.eclipse
SELECT CURRENT_TIMESTAMP, whn
  FROM eclipse

See also

Language:Project:Language policy English  • Deutsch
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects