Latest revision as of 17:50, 21 October 2012

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

@@ Line 19: / Line 19: @@
 <div class='ht'>
 <div class=params>schema:gisq</div>
-With a <code>GROUP BY</code> <code>region</code> 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.
 <source lang='sql' class='def e-oracle'>
 SELECT CURRENT_TIMESTAMP, whn