Connor: Created page with "Get the current date and/or time

schema:gisq

SQL Standard specifies CURRENT_TIMESTAMP, [[CURRENT_DATE |C..."

2012-07-17T15:06:55Z

Created page with "Get the current date and/or time <div class='ht'> <div class=params>schema:gisq</div> <div> SQL Standard specifies CURRENT_TIMESTAMP, [[CURRENT_DATE |C..."

New page

Get the current date and/or time
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
SQL Standard specifies [[CURRENT_TIMESTAMP |CURRENT_TIMESTAMP]], [[CURRENT_DATE |CURRENT_DATE]] and CURRENT_TIME. These are widely ignored :(
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-access'>SELECT Now(), Date(), Time()
FROM nix</source>
<source lang='sql' class='def e-sqlserver e-sybase'>SELECT GETDATE()
FROM nix</source>
<source lang='sql' class='def e-oracle'>SELECT SYSDATE, SYSTIMESTAMP
FROM gisq.nix</source>
<source lang='sql' class='def'>SELECT CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME
FROM nix</source>

<div class="ecomm e-postgres" style="display: none"></div>
<div class="ecomm e-oracle" style="display: none"></div>
<div class="ecomm e-mysql" style="display: none"></div>
</div>
{{Functions ref}}

Get a date and time right now - Revision history

Connor: Created page with "Get the current date and/or time schema:gisq SQL Standard specifies CURRENT_TIMESTAMP, [[CURRENT_DATE |C..."

Connor: Created page with "Get the current date and/or time

schema:gisq

SQL Standard specifies CURRENT_TIMESTAMP, [[CURRENT_DATE |C..."