Latest revision as of 18: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 9: / Line 9: @@
 <tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr>
 </table>
 <h1>CURRENT_TIMESTAMP</h1>
 <p>CURRENT_TIMESTAMP returns the current date and time. </p>
@@ Line 16: / Line 17: @@
 </pre>
-<div class='qu'>
+<div class='ht'>
-With a <code>GROUP BY</code> <code>region</code> statement each region shows up just once.
+<div class=params>schema:gisq</div>
-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
+  FROM gisq.eclipse
+</source>
 <source lang='sql' class='def'>
 SELECT CURRENT_TIMESTAMP, whn
@@ Line 29: / Line 33: @@
    <li>[[%2B(dates) |+(dates) function]]</li>
 </ul>
+{{Languages}}