This is an automated email from the ASF dual-hosted git repository. yamamuro pushed a commit to branch branch-3.0 in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/branch-3.0 by this push: new 0f02997 [SPARK-31465][SQL][DOCS][FOLLOW-UP] Document Literal in SQL Reference 0f02997 is described below commit 0f0299749421bc7328c6b962a9305bf460f51ddf Author: Huaxin Gao <huax...@us.ibm.com> AuthorDate: Thu Apr 23 15:03:20 2020 +0900 [SPARK-31465][SQL][DOCS][FOLLOW-UP] Document Literal in SQL Reference ### What changes were proposed in this pull request? Need to address a few more comments ### Why are the changes needed? Fix a few problems ### Does this PR introduce any user-facing change? Yes ### How was this patch tested? Manually build and check Closes #28306 from huaxingao/literal-folllowup. Authored-by: Huaxin Gao <huax...@us.ibm.com> Signed-off-by: Takeshi Yamamuro <yamam...@apache.org> (cherry picked from commit f543d6a1ee76de8cae417ff480fa9c0e0ce5343d) Signed-off-by: Takeshi Yamamuro <yamam...@apache.org> --- docs/sql-ref-literals.md | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) diff --git a/docs/sql-ref-literals.md b/docs/sql-ref-literals.md index 7cf078c..0088f79 100644 --- a/docs/sql-ref-literals.md +++ b/docs/sql-ref-literals.md @@ -437,11 +437,11 @@ SELECT TIMESTAMP '1997-01-31 09:26:56.123' AS col; |1997-01-31 09:26:56.123| +-----------------------+ -SELECT TIMESTAMP '1997-01-31 09:26:56.66666666CST' AS col; +SELECT TIMESTAMP '1997-01-31 09:26:56.66666666UTC+08:00' AS col; +--------------------------+ | col | +--------------------------+ -|1997-01-31 07:26:56.666666| +|1997-01-30 17:26:56.666666| +--------------------------+ SELECT TIMESTAMP '1997-01' AS col; @@ -508,7 +508,7 @@ SELECT INTERVAL -2 HOUR '3' MINUTE AS col; |-1 hours -57 minutes| +--------------------+ -SELECT INTERVAL 'INTERVAL 1 YEAR 2 DAYS 3 HOURS'; +SELECT INTERVAL '1 YEAR 2 DAYS 3 HOURS'; +----------------------+ | col| +----------------------+ @@ -523,6 +523,13 @@ SELECT INTERVAL 1 YEARS 2 MONTH 3 WEEK 4 DAYS 5 HOUR 6 MINUTES 7 SECOND 8 |1 years 2 months 25 days 5 hours 6 minutes 7.008009 seconds| +-----------------------------------------------------------+ +SELECT INTERVAL '2-3' YEAR TO MONTH AS col; ++----------------+ +| col| ++----------------+ +|2 years 3 months| ++----------------+ + SELECT INTERVAL '20 15:40:32.99899999' DAY TO SECOND AS col; +---------------------------------------------+ | col| --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org For additional commands, e-mail: commits-h...@spark.apache.org