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/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 13cba3265d Publish built docs triggered by
4a1f69f9bcf886c98c05dbbd87e409d3c8cf3a53
13cba3265d is described below
commit 13cba3265d001be80f1be8b3a75667f7b0265bd2
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Dec 23 04:19:52 2025 +0000
Publish built docs triggered by 4a1f69f9bcf886c98c05dbbd87e409d3c8cf3a53
---
_sources/user-guide/sql/scalar_functions.md.txt | 11 +++++++++++
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 11 +++++++++++
3 files changed, 23 insertions(+), 1 deletion(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index ce7ea85a81..3f0939d00d 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -2488,6 +2488,17 @@ FROM VALUES ('2023-01-01T18:18:18Z'),
('2023-01-03T19:00:03Z') t(time);
| 2023-01-03T03:00:00 |
+---------------------+
2 row(s) fetched.
+
+-- Bin the time into 15 minute intervals starting at 1 min
+> SELECT date_bin(interval '15 minutes', time, TIME '00:01:00') as bin
+FROM VALUES (TIME '02:18:18'), (TIME '19:00:03') t(time);
++----------+
+| bin |
++----------+
+| 02:16:00 |
+| 18:46:00 |
++----------+
+2 row(s) fetched.
```
### `date_format`
diff --git a/searchindex.js b/searchindex.js
index 95105d72ba..bdf49c6b99 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[61,"op-neq"]],"!~":[[61,"op-re-not-match"]],"!~*":[[61,"op-re-not-match-i"]],"!~~":[[61,"id19"]],"!~~*":[[61,"id20"]],"#":[[61,"op-bit-xor"]],"%":[[61,"op-modulo"]],"&":[[61,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[13,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[61,"op-multiply"]],"+":[[61,"op-plus"]],"-":[[61,"op-minus"]],"/":[[61,"op-divide"]],"<":[[61,"op-lt"]],"<
[...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[61,"op-neq"]],"!~":[[61,"op-re-not-match"]],"!~*":[[61,"op-re-not-match-i"]],"!~~":[[61,"id19"]],"!~~*":[[61,"id20"]],"#":[[61,"op-bit-xor"]],"%":[[61,"op-modulo"]],"&":[[61,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[13,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[61,"op-multiply"]],"+":[[61,"op-plus"]],"-":[[61,"op-minus"]],"/":[[61,"op-divide"]],"<":[[61,"op-lt"]],"<
[...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index cfa7dd1920..c75d487469 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2982,6 +2982,17 @@ Can be a constant, column, or function.</p></li>
<span class="o">|</span><span class="w"> </span><span
class="mi">2023</span><span class="o">-</span><span class="mi">01</span><span
class="o">-</span><span class="mi">03</span><span class="n">T03</span><span
class="p">:</span><span class="mi">00</span><span class="p">:</span><span
class="mi">00</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="mi">2</span><span class="w"> </span><span
class="k">row</span><span class="p">(</span><span class="n">s</span><span
class="p">)</span><span class="w"> </span><span class="n">fetched</span><span
class="p">.</span>
+
+<span class="c1">-- Bin the time into 15 minute intervals starting at 1
min</span>
+<span class="o">></span><span class="w"> </span><span
class="k">SELECT</span><span class="w"> </span><span
class="n">date_bin</span><span class="p">(</span><span
class="nb">interval</span><span class="w"> </span><span class="s1">'15
minutes'</span><span class="p">,</span><span class="w"> </span><span
class="k">time</span><span class="p">,</span><span class="w"> </span><span
class="k">TIME</span><span class="w"> </span><span
class="s1">'00:01:00'</span><span class="p"> [...]
+<span class="k">FROM</span><span class="w"> </span><span
class="k">VALUES</span><span class="w"> </span><span class="p">(</span><span
class="k">TIME</span><span class="w"> </span><span
class="s1">'02:18:18'</span><span class="p">),</span><span class="w">
</span><span class="p">(</span><span class="k">TIME</span><span class="w">
</span><span class="s1">'19:00:03'</span><span class="p">)</span><span
class="w"> </span><span class="n">t</span><span class="p">(</span><span cl
[...]
+<span class="o">+</span><span class="c1">----------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">bin</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="mi">02</span><span class="p">:</span><span class="mi">16</span><span
class="p">:</span><span class="mi">00</span><span class="w"> </span><span
class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span
class="mi">18</span><span class="p">:</span><span class="mi">46</span><span
class="p">:</span><span class="mi">00</span><span class="w"> </span><span
class="o">|</span>
+<span class="o">+</span><span class="c1">----------+</span>
+<span class="mi">2</span><span class="w"> </span><span
class="k">row</span><span class="p">(</span><span class="n">s</span><span
class="p">)</span><span class="w"> </span><span class="n">fetched</span><span
class="p">.</span>
</pre></div>
</div>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
