You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by as...@apache.org on 2022/11/06 01:06:36 UTC
[calcite-site] branch main updated: Website deployed from calcite@f7bf867ba96578e7cc40e2aac1adf47015d06913
This is an automated email from the ASF dual-hosted git repository.
asf-ci-deploy pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/calcite-site.git
The following commit(s) were added to refs/heads/main by this push:
new 9f7ddd77 Website deployed from calcite@f7bf867ba96578e7cc40e2aac1adf47015d06913
9f7ddd77 is described below
commit 9f7ddd7725535094de079aaf8e8d41aa0fc6bb24
Author: julianhyde <ju...@users.noreply.github.com>
AuthorDate: Sun Nov 6 01:06:31 2022 +0000
Website deployed from calcite@f7bf867ba96578e7cc40e2aac1adf47015d06913
---
docs/reference.html | 30 ++++++++++++++++++++++++++++++
1 file changed, 30 insertions(+)
diff --git a/docs/reference.html b/docs/reference.html
index 3d9d9438..09f0f127 100644
--- a/docs/reference.html
+++ b/docs/reference.html
@@ -5029,6 +5029,7 @@ connect string parameter.</p>
<li>‘b’ for Google BigQuery (‘fun=bigquery’ in the connect string),</li>
<li>‘h’ for Apache Hive (‘fun=hive’ in the connect string),</li>
<li>‘m’ for MySQL (‘fun=mysql’ in the connect string),</li>
+ <li>‘q’ for Microsoft SQL Server (‘fun=mssql’ in the connect string),</li>
<li>‘o’ for Oracle (‘fun=oracle’ in the connect string),</li>
<li>‘p’ for PostgreSQL (‘fun=postgresql’ in the connect string),</li>
<li>’s’ for Apache Spark (‘fun=spark’ in the connect string).</li>
@@ -5129,6 +5130,24 @@ semantics.</p>
<td style="text-align: left">b</td>
<td style="text-align: left">DATE(string)</td>
<td style="text-align: left">Equivalent to <code class="language-plaintext highlighter-rouge">CAST(string AS DATE)</code>
+</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">p q</td>
+ <td style="text-align: left">DATEADD(timeUnit, integer, datetime)</td>
+ <td style="text-align: left">Equivalent to <code class="language-plaintext highlighter-rouge">TIMESTAMPADD(timeUnit, integer, datetime)</code>
+</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">p q</td>
+ <td style="text-align: left">DATEDIFF(timeUnit, datetime, datetime2)</td>
+ <td style="text-align: left">Equivalent to <code class="language-plaintext highlighter-rouge">TIMESTAMPDIFF(timeUnit, datetime, datetime2)</code>
+</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">q</td>
+ <td style="text-align: left">DATEPART(timeUnit, datetime)</td>
+ <td style="text-align: left">Equivalent to <code class="language-plaintext highlighter-rouge">EXTRACT(timeUnit FROM datetime)</code>
</td>
</tr>
<tr>
@@ -5136,6 +5155,12 @@ semantics.</p>
<td style="text-align: left">DATE_FROM_UNIX_DATE(integer)</td>
<td style="text-align: left">Returns the DATE that is <em>integer</em> days after 1970-01-01</td>
</tr>
+ <tr>
+ <td style="text-align: left">p</td>
+ <td style="text-align: left">DATE_PART(timeUnit, datetime)</td>
+ <td style="text-align: left">Equivalent to <code class="language-plaintext highlighter-rouge">EXTRACT(timeUnit FROM datetime)</code>
+</td>
+ </tr>
<tr>
<td style="text-align: left">o</td>
<td style="text-align: left">DECODE(value, value1, result1 [, valueN, resultN ]* [, default ])</td>
@@ -5400,6 +5425,11 @@ semantics.</p>
<p>Note:</p>
<ul>
+ <li>Calcite has no Redshift library, so the Postgres library
+is used instead. The functions <code class="language-plaintext highlighter-rouge">DATEADD</code>, <code class="language-plaintext highlighter-rouge">DATEDIFF</code> are
+implemented in Redshift and not Postgres but nevertheless
+appear in Calcite’s Postgres library</li>
+ <li>Functions <code class="language-plaintext highlighter-rouge">DATEADD</code>, <code class="language-plaintext highlighter-rouge">DATEDIFF</code>, <code class="language-plaintext highlighter-rouge">DATE_PART</code> require the Babel parser</li>
<li>
<code class="language-plaintext highlighter-rouge">JSON_TYPE</code> / <code class="language-plaintext highlighter-rouge">JSON_DEPTH</code> / <code class="language-plaintext highlighter-rouge">JSON_PRETTY</code> / <code class="language-plaintext highlighter-rouge">JSON_STORAGE_SIZE</code> return null if the argument is null</li>
<li>