CURRENT TIMESTAMP

From SQLZOO
Revision as of 18:50, 21 October 2012 by Peter (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, 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: English  • Deutsch
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense