You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@arrow.apache.org by gi...@apache.org on 2023/11/04 09:43:03 UTC
(arrow-datafusion) branch asf-site updated: Publish built docs triggered by 8acdb07a59103d8a22fe64ac51bfe6bb5b07a6f5
This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 613d9027fa Publish built docs triggered by 8acdb07a59103d8a22fe64ac51bfe6bb5b07a6f5
613d9027fa is described below
commit 613d9027fa312126f66a695bbbbb86084c0fe300
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Sat Nov 4 09:42:58 2023 +0000
Publish built docs triggered by 8acdb07a59103d8a22fe64ac51bfe6bb5b07a6f5
---
_sources/user-guide/sql/scalar_functions.md.txt | 49 ++++++++++++++-----------
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 49 ++++++++++++++-----------
3 files changed, 55 insertions(+), 45 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index b7426baea3..be05084fb2 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1391,10 +1391,11 @@ extract(field FROM source)
### `to_timestamp`
-Converts a value to RFC3339 nanosecond timestamp format (`YYYY-MM-DDT00:00:00Z`).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix second timestamps and
-return the corresponding RFC3339 timestamp.
+Converts a value to a timestamp (`YYYY-MM-DDT00:00:00Z`).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. '2023-07-20T05:44:00')
+Integers and unsigned integers are interpreted as seconds since the unix epoch (`1970-01-01T00:00:00Z`)
+return the corresponding timestamp.
```
to_timestamp(expression)
@@ -1407,10 +1408,11 @@ to_timestamp(expression)
### `to_timestamp_millis`
-Converts a value to RFC3339 millisecond timestamp format (`YYYY-MM-DDT00:00:00.000Z`).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix nanosecond timestamps and
-return the corresponding RFC3339 timestamp.
+Converts a value to a timestamp (`YYYY-MM-DDT00:00:00.000Z`).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. '2023-07-20T05:44:00')
+Integers and unsigned integers are interpreted as milliseconds since the unix epoch (`1970-01-01T00:00:00Z`)
+return the corresponding timestamp.
```
to_timestamp_millis(expression)
@@ -1423,10 +1425,11 @@ to_timestamp_millis(expression)
### `to_timestamp_micros`
-Converts a value to RFC3339 microsecond timestamp format (`YYYY-MM-DDT00:00:00.000000Z`).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix nanosecond timestamps and
-return the corresponding RFC3339 timestamp.
+Converts a value to a timestamp (`YYYY-MM-DDT00:00:00.000000Z`).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. '2023-07-20T05:44:00')
+Integers and unsigned integers are interpreted as microseconds since the unix epoch (`1970-01-01T00:00:00Z`)
+return the corresponding timestamp.
```
to_timestamp_nanos(expression)
@@ -1434,10 +1437,11 @@ to_timestamp_nanos(expression)
### `to_timestamp_nanos`
-Converts a value to RFC3339 nanosecond timestamp format (`YYYY-MM-DDT00:00:00.000000000Z`).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix nanosecond timestamps and
-return the corresponding RFC3339 timestamp.
+Converts a value to a timestamp (`YYYY-MM-DDT00:00:00.000000000Z`).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. '2023-07-20T05:44:00')
+Integers and unsigned integers are interpreted as nanoseconds since the unix epoch (`1970-01-01T00:00:00Z`)
+return the corresponding timestamp.
```
to_timestamp_nanos(expression)
@@ -1450,10 +1454,11 @@ to_timestamp_nanos(expression)
### `to_timestamp_seconds`
-Converts a value to RFC3339 second timestamp format (`YYYY-MM-DDT00:00:00Z`).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix nanosecond timestamps and
-return the corresponding RFC3339 timestamp.
+Converts a value to a timestamp (`YYYY-MM-DDT00:00:00.000Z`).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. '2023-07-20T05:44:00')
+Integers and unsigned integers are interpreted as seconds since the unix epoch (`1970-01-01T00:00:00Z`)
+return the corresponding timestamp.
```
to_timestamp_seconds(expression)
@@ -1467,8 +1472,8 @@ to_timestamp_seconds(expression)
### `from_unixtime`
Converts an integer to RFC3339 timestamp format (`YYYY-MM-DDT00:00:00.000000000Z`).
-Input is parsed as a Unix nanosecond timestamp and returns the corresponding
-RFC3339 timestamp.
+Integers and unsigned integers are interpreted as nanoseconds since the unix epoch (`1970-01-01T00:00:00Z`)
+return the corresponding timestamp.
```
from_unixtime(expression)
diff --git a/searchindex.js b/searchindex.js
index 90e88b6203..6ff62c9c02 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["contributor-guide/architecture", "contributor-guide/communication", "contributor-guide/index", "contributor-guide/quarterly_roadmap", "contributor-guide/roadmap", "contributor-guide/specification/index", "contributor-guide/specification/invariants", "contributor-guide/specification/output-field-name-semantic", "index", "library-user-guide/adding-udfs", "library-user-guide/building-logical-plans", "library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
+Search.setIndex({"docnames": ["contributor-guide/architecture", "contributor-guide/communication", "contributor-guide/index", "contributor-guide/quarterly_roadmap", "contributor-guide/roadmap", "contributor-guide/specification/index", "contributor-guide/specification/invariants", "contributor-guide/specification/output-field-name-semantic", "index", "library-user-guide/adding-udfs", "library-user-guide/building-logical-plans", "library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index 44b75f2ef3..cc90471aa9 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -4371,10 +4371,11 @@ Can be a constant, column, or function.</p></li>
</section>
<section id="to-timestamp">
<h3><code class="docutils literal notranslate"><span class="pre">to_timestamp</span></code><a class="headerlink" href="#to-timestamp" title="Link to this heading">¶</a></h3>
-<p>Converts a value to RFC3339 nanosecond timestamp format (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00Z</span></code>).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix second timestamps and
-return the corresponding RFC3339 timestamp.</p>
+<p>Converts a value to a timestamp (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00Z</span></code>).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. ‘2023-07-20T05:44:00’)
+Integers and unsigned integers are interpreted as seconds since the unix epoch (<code class="docutils literal notranslate"><span class="pre">1970-01-01T00:00:00Z</span></code>)
+return the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
@@ -4388,10 +4389,11 @@ Can be a constant, column, or function, and any combination of arithmetic operat
</section>
<section id="to-timestamp-millis">
<h3><code class="docutils literal notranslate"><span class="pre">to_timestamp_millis</span></code><a class="headerlink" href="#to-timestamp-millis" title="Link to this heading">¶</a></h3>
-<p>Converts a value to RFC3339 millisecond timestamp format (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00.000Z</span></code>).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix nanosecond timestamps and
-return the corresponding RFC3339 timestamp.</p>
+<p>Converts a value to a timestamp (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00.000Z</span></code>).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. ‘2023-07-20T05:44:00’)
+Integers and unsigned integers are interpreted as milliseconds since the unix epoch (<code class="docutils literal notranslate"><span class="pre">1970-01-01T00:00:00Z</span></code>)
+return the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp_millis</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
@@ -4405,20 +4407,22 @@ Can be a constant, column, or function, and any combination of arithmetic operat
</section>
<section id="to-timestamp-micros">
<h3><code class="docutils literal notranslate"><span class="pre">to_timestamp_micros</span></code><a class="headerlink" href="#to-timestamp-micros" title="Link to this heading">¶</a></h3>
-<p>Converts a value to RFC3339 microsecond timestamp format (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00.000000Z</span></code>).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix nanosecond timestamps and
-return the corresponding RFC3339 timestamp.</p>
+<p>Converts a value to a timestamp (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00.000000Z</span></code>).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. ‘2023-07-20T05:44:00’)
+Integers and unsigned integers are interpreted as microseconds since the unix epoch (<code class="docutils literal notranslate"><span class="pre">1970-01-01T00:00:00Z</span></code>)
+return the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp_nanos</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
</section>
<section id="to-timestamp-nanos">
<h3><code class="docutils literal notranslate"><span class="pre">to_timestamp_nanos</span></code><a class="headerlink" href="#to-timestamp-nanos" title="Link to this heading">¶</a></h3>
-<p>Converts a value to RFC3339 nanosecond timestamp format (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00.000000000Z</span></code>).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix nanosecond timestamps and
-return the corresponding RFC3339 timestamp.</p>
+<p>Converts a value to a timestamp (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00.000000000Z</span></code>).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. ‘2023-07-20T05:44:00’)
+Integers and unsigned integers are interpreted as nanoseconds since the unix epoch (<code class="docutils literal notranslate"><span class="pre">1970-01-01T00:00:00Z</span></code>)
+return the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp_nanos</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
@@ -4432,10 +4436,11 @@ Can be a constant, column, or function, and any combination of arithmetic operat
</section>
<section id="to-timestamp-seconds">
<h3><code class="docutils literal notranslate"><span class="pre">to_timestamp_seconds</span></code><a class="headerlink" href="#to-timestamp-seconds" title="Link to this heading">¶</a></h3>
-<p>Converts a value to RFC3339 second timestamp format (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00Z</span></code>).
-Supports timestamp, integer, and unsigned integer types as input.
-Integers and unsigned integers are parsed as Unix nanosecond timestamps and
-return the corresponding RFC3339 timestamp.</p>
+<p>Converts a value to a timestamp (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00.000Z</span></code>).
+Supports strings, integer, and unsigned integer types as input.
+Strings are parsed as RFC3339 (e.g. ‘2023-07-20T05:44:00’)
+Integers and unsigned integers are interpreted as seconds since the unix epoch (<code class="docutils literal notranslate"><span class="pre">1970-01-01T00:00:00Z</span></code>)
+return the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp_seconds</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
@@ -4450,8 +4455,8 @@ Can be a constant, column, or function, and any combination of arithmetic operat
<section id="from-unixtime">
<h3><code class="docutils literal notranslate"><span class="pre">from_unixtime</span></code><a class="headerlink" href="#from-unixtime" title="Link to this heading">¶</a></h3>
<p>Converts an integer to RFC3339 timestamp format (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00.000000000Z</span></code>).
-Input is parsed as a Unix nanosecond timestamp and returns the corresponding
-RFC3339 timestamp.</p>
+Integers and unsigned integers are interpreted as nanoseconds since the unix epoch (<code class="docutils literal notranslate"><span class="pre">1970-01-01T00:00:00Z</span></code>)
+return the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">from_unixtime</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>