You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2026/07/29 17:08:51 UTC
(datafusion) branch asf-site updated: Publish built docs triggered by 2fb472a2173baeab28f6b498e0aa63ebd893ee77
This is an automated email from the ASF dual-hosted git repository.
github-actions[bot] pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 099f193f22 Publish built docs triggered by 2fb472a2173baeab28f6b498e0aa63ebd893ee77
099f193f22 is described below
commit 099f193f22854e86a9e060c46200eff49b51995a
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Wed Jul 29 17:08:45 2026 +0000
Publish built docs triggered by 2fb472a2173baeab28f6b498e0aa63ebd893ee77
---
_sources/user-guide/sql/scalar_functions.md.txt | 19 ++++++++++++-------
user-guide/sql/scalar_functions.html | 19 ++++++++++++-------
2 files changed, 24 insertions(+), 14 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index a285b9e5f5..a865a3d182 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -2851,7 +2851,7 @@ to_date('2017-05-31', '%Y-%m-%d')
- **expression**: String expression to operate on. Can be a constant, column, or function, and any combination of operators.
- **format_n**: Optional [Chrono format](https://docs.rs/chrono/latest/chrono/format/strftime/index.html) strings to use to parse the expression. Formats will be tried in the order
they appear with the first successful one being returned. If none of the formats successfully parse the expression
- an error will be returned.
+ an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
#### Example
@@ -3006,7 +3006,8 @@ to_timestamp(expression[, ..., format_n])
- **format_n**:
Optional [Chrono format](https://docs.rs/chrono/latest/chrono/format/strftime/index.html) strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
- parse the expression an error will be returned. Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
+ parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+ Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
only supported at the end of the string preceded by a space.
#### Example
@@ -3050,7 +3051,8 @@ to_timestamp_micros(expression[, ..., format_n])
- **format_n**:
Optional [Chrono format](https://docs.rs/chrono/latest/chrono/format/strftime/index.html) strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
- parse the expression an error will be returned. Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
+ parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+ Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
only supported at the end of the string preceded by a space.
#### Example
@@ -3094,7 +3096,8 @@ to_timestamp_millis(expression[, ..., format_n])
- **format_n**:
Optional [Chrono format](https://docs.rs/chrono/latest/chrono/format/strftime/index.html) strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
- parse the expression an error will be returned. Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
+ parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+ Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
only supported at the end of the string preceded by a space.
#### Example
@@ -3137,7 +3140,8 @@ to_timestamp_nanos(expression[, ..., format_n])
- **format_n**:
Optional [Chrono format](https://docs.rs/chrono/latest/chrono/format/strftime/index.html) strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
- parse the expression an error will be returned. Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
+ parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+ Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
only supported at the end of the string preceded by a space.
#### Example
@@ -3181,7 +3185,8 @@ to_timestamp_seconds(expression[, ..., format_n])
- **format_n**:
Optional [Chrono format](https://docs.rs/chrono/latest/chrono/format/strftime/index.html) strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
- parse the expression an error will be returned. Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
+ parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+ Note: parsing of named timezones (e.g. 'America/New_York') using %Z is
only supported at the end of the string preceded by a space.
#### Example
@@ -3218,7 +3223,7 @@ to_unixtime(expression[, ..., format_n])
#### Arguments
- **expression**: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.
-- **format_n**: Optional [Chrono format](https://docs.rs/chrono/latest/chrono/format/strftime/index.html) strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned.
+- **format_n**: Optional [Chrono format](https://docs.rs/chrono/latest/chrono/format/strftime/index.html) strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
#### Example
diff --git a/user-guide/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index 471746e23e..9c3ceeb1bd 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -3396,7 +3396,7 @@ Returns the corresponding date.</p>
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order
they appear with the first successful one being returned. If none of the formats successfully parse the expression
-an error will be returned.</p></li>
+an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.</p></li>
</ul>
</section>
<section id="id195">
@@ -3549,7 +3549,8 @@ The time zone can be a value like +00:00, ‘Europe/London’ etc.</p>
<li><p><strong>format_n</strong>:
Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
-parse the expression an error will be returned. Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
+parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
only supported at the end of the string preceded by a space.</p></li>
</ul>
</section>
@@ -3592,7 +3593,8 @@ The time zone can be a value like +00:00, ‘Europe/London’ etc.</p>
<li><p><strong>format_n</strong>:
Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
-parse the expression an error will be returned. Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
+parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
only supported at the end of the string preceded by a space.</p></li>
</ul>
</section>
@@ -3635,7 +3637,8 @@ The time zone can be a value like +00:00, ‘Europe/London’ etc.</p>
<li><p><strong>format_n</strong>:
Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
-parse the expression an error will be returned. Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
+parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
only supported at the end of the string preceded by a space.</p></li>
</ul>
</section>
@@ -3677,7 +3680,8 @@ The time zone can be a value like +00:00, ‘Europe/London’ etc.</p>
<li><p><strong>format_n</strong>:
Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
-parse the expression an error will be returned. Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
+parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
only supported at the end of the string preceded by a space.</p></li>
</ul>
</section>
@@ -3720,7 +3724,8 @@ The time zone can be a value like +00:00, ‘Europe/London’ etc.</p>
<li><p><strong>format_n</strong>:
Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression.
Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully
-parse the expression an error will be returned. Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
+parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.
+Note: parsing of named timezones (e.g. ‘America/New_York’) using %Z is
only supported at the end of the string preceded by a space.</p></li>
</ul>
</section>
@@ -3757,7 +3762,7 @@ Integers, unsigned integers, and floats are interpreted as seconds since the uni
<h4>Arguments<a class="headerlink" href="#id210" title="Link to this heading">#</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.</p></li>
-<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned.</p></li>
+<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned. NULL formats are skipped. If every format is NULL the result is NULL.</p></li>
</ul>
</section>
<section id="id211">
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org