CURRENT TIMESTAMP

Compatibility

CURRENT_TIMESTAMP
Engine	OK	Alternative
ingres	Yes
mysql	Yes
oracle	Yes
postgres	Yes
sqlserver	Yes

CURRENT_TIMESTAMP

CURRENT_TIMESTAMP returns the current date and time.

 CURRENT_TIMESTAMP -> '2006-12-31 18:03:44'  

schema:gisq

With a GROUP BY region statement each region shows up just once. The MAX column gives the "largest" name in the region in the context of strings this is the last name alphabetically.

SELECT CURRENT_TIMESTAMP, whn
  FROM gisq.eclipse

SELECT CURRENT_TIMESTAMP, whn
  FROM eclipse

See also

• +(dates) function

Language:	English  • Deutsch