Difference between revisions of "CURRENT TIMESTAMP"
From SQLZOO
| Line 9: | Line 9: | ||
<tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr> | <tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr> | ||
</table> | </table> | ||
| + | |||
<h1>CURRENT_TIMESTAMP</h1> | <h1>CURRENT_TIMESTAMP</h1> | ||
<p>CURRENT_TIMESTAMP returns the current date and time. </p> | <p>CURRENT_TIMESTAMP returns the current date and time. </p> | ||
| Line 34: | Line 35: | ||
<li>[[%2B(dates) |+(dates) function]]</li> | <li>[[%2B(dates) |+(dates) function]]</li> | ||
</ul> | </ul> | ||
| + | |||
| + | {{Languages}} | ||
Revision as of 17:42, 21 October 2012
| 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
| Language: | English • Deutsch |
|---|
