http://www.sqlzoo.net/w/index.php?title=CURRENT_TIMESTAMP&feed=atom&action=historyCURRENT TIMESTAMP - Revision history2013-05-20T00:49:49ZRevision history for this page on the wikiMediaWiki 1.20.4http://www.sqlzoo.net/w/index.php?title=CURRENT_TIMESTAMP&diff=4222&oldid=prevPeter at 17:50, 21 October 20122012-10-21T17:50:00Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 17:50, 21 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 19:</td>
<td colspan="2" class="diff-lineno">Line 19:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class=params>schema:gisq</div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class=params>schema:gisq</div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">With a <code>GROUP BY</code> <code>region</code> statement each region shows up just once.</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">The MAX column gives the "largest" name in the region in the context of strings this is the last name alphabetically. </del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT CURRENT_TIMESTAMP, whn</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT CURRENT_TIMESTAMP, whn</div></td></tr>
</table>Peterhttp://www.sqlzoo.net/w/index.php?title=CURRENT_TIMESTAMP&diff=4221&oldid=prevPeter at 17:42, 21 October 20122012-10-21T17:42:48Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 17:42, 21 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 9:</td>
<td colspan="2" class="diff-lineno">Line 9:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>CURRENT_TIMESTAMP</h1></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>CURRENT_TIMESTAMP</h1></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>CURRENT_TIMESTAMP returns the current date and time. </p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>CURRENT_TIMESTAMP returns the current date and time. </p></div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 34:</td>
<td colspan="2" class="diff-lineno">Line 35:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[%2B(dates) |+(dates) function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[%2B(dates) |+(dates) function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">{{Languages}}</ins></div></td></tr>
</table>Peterhttp://www.sqlzoo.net/w/index.php?title=CURRENT_TIMESTAMP&diff=1359&oldid=prevConnor at 14:48, 16 July 20122012-07-16T14:48:48Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:48, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 17:</td>
<td colspan="2" class="diff-lineno">Line 17:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"><div class=params>schema:gisq</div></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>With a <code>GROUP BY</code> <code>region</code> statement each region shows up just once.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>With a <code>GROUP BY</code> <code>region</code> statement each region shows up just once.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The MAX column gives the "largest" name in the region in the context of strings this is the last name alphabetically.  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The MAX column gives the "largest" name in the region in the context of strings this is the last name alphabetically.  </div></td></tr>
</table>Connorhttp://www.sqlzoo.net/w/index.php?title=CURRENT_TIMESTAMP&diff=1358&oldid=prevConnor at 14:46, 16 July 20122012-07-16T14:46:38Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:46, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 16:</td>
<td colspan="2" class="diff-lineno">Line 16:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class='<del class="diffchange diffchange-inline">qu</del>'></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class='<ins class="diffchange diffchange-inline">ht</ins>'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>With a <code>GROUP BY</code> <code>region</code> statement each region shows up just once.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>With a <code>GROUP BY</code> <code>region</code> statement each region shows up just once.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The MAX column gives the "largest" name in the region in the context of strings this is the last name alphabetically.  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The MAX column gives the "largest" name in the region in the context of strings this is the last name alphabetically.  </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"><source lang='sql' class='def e-oracle'></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">SELECT CURRENT_TIMESTAMP, whn</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">  FROM gisq.eclipse</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></source></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT CURRENT_TIMESTAMP, whn</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT CURRENT_TIMESTAMP, whn</div></td></tr>
</table>Connorhttp://www.sqlzoo.net/w/index.php?title=CURRENT_TIMESTAMP&diff=1357&oldid=prevConnor at 14:45, 16 July 20122012-07-16T14:45:59Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:45, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 27:</td>
<td colspan="2" class="diff-lineno">Line 27:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[+(dates) function]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">%2B(dates) |</ins>+(dates) function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
</table>Connorhttp://www.sqlzoo.net/w/index.php?title=CURRENT_TIMESTAMP&diff=1291&oldid=prevConnor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CURRENT_TIMESTAMP</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>''..."2012-07-16T10:22:17Z<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CURRENT_TIMESTAMP</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>''..."</p>
<p><b>New page</b></p><div><table align='right' border='1'><br />
<caption>Compatibility</caption><br />
<tr><th colspan='3'>CURRENT_TIMESTAMP</th></tr><br />
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br />
<tr><td align='left'>ingres</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>mysql</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>oracle</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>postgres</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr><br />
</table><br />
<h1>CURRENT_TIMESTAMP</h1><br />
<p>CURRENT_TIMESTAMP returns the current date and time. </p><br />
<p></p> <br />
<pre style='width:80ex'><br />
CURRENT_TIMESTAMP -> '2006-12-31 18:03:44' <br />
</pre><br />
<br />
<div class='qu'><br />
With a <code>GROUP BY</code> <code>region</code> statement each region shows up just once.<br />
The MAX column gives the "largest" name in the region in the context of strings this is the last name alphabetically. <br />
<source lang='sql' class='def'><br />
SELECT CURRENT_TIMESTAMP, whn<br />
FROM eclipse<br />
</source><br />
</div><br />
<br />
<p>See also</p><br />
<ul><br />
<li>[[+(dates) function]]</li><br />
</ul></div>Connor