This is an automated email from the ASF dual-hosted git repository.
gengliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/master by this push:
new 3acc4b9 [SPARK-35971][SQL] Rename the type name of TimestampNTZType
as "timestamp_ntz"
3acc4b9 is described below
commit 3acc4b973b57f88fbe681c7db89cd55699750178
Author: Gengliang Wang <gengli...@apache.org>
AuthorDate: Thu Jul 1 20:50:19 2021 +0800
[SPARK-35971][SQL] Rename the type name of TimestampNTZType as
"timestamp_ntz"
### What changes were proposed in this pull request?
Rename the type name string of TimestampNTZType from "timestamp without
time zone" to "timestamp_ntz".
### Why are the changes needed?
This is to make the column header shorter and simpler.
Snowflake and Flink uses similar approach:
https://docs.snowflake.com/en/sql-reference/data-types-datetime.html
https://ci.apache.org/projects/flink/flink-docs-master/docs/dev/table/concepts/timezone/
### Does this PR introduce _any_ user-facing change?
No, the new timestamp type is not released yet.
### How was this patch tested?
Unit tests
Closes #33173 from gengliangwang/reviseTypeName.
Authored-by: Gengliang Wang <gengli...@apache.org>
Signed-off-by: Gengliang Wang <gengli...@apache.org>
---
.../apache/spark/sql/types/TimestampNTZType.scala | 2 +-
.../sql/catalyst/expressions/CastSuiteBase.scala | 4 +-
.../sql-functions/sql-expression-schema.md | 4 +-
.../sql-tests/results/ansi/datetime.sql.out | 92 +++++++++---------
.../sql-tests/results/datetime-legacy.sql.out | 108 ++++++++++-----------
.../resources/sql-tests/results/datetime.sql.out | 108 ++++++++++-----------
6 files changed, 159 insertions(+), 159 deletions(-)
diff --git
a/sql/catalyst/src/main/scala/org/apache/spark/sql/types/TimestampNTZType.scala
b/sql/catalyst/src/main/scala/org/apache/spark/sql/types/TimestampNTZType.scala
index 347fd4a..f7d20a0 100644
---
a/sql/catalyst/src/main/scala/org/apache/spark/sql/types/TimestampNTZType.scala
+++
b/sql/catalyst/src/main/scala/org/apache/spark/sql/types/TimestampNTZType.scala
@@ -48,7 +48,7 @@ class TimestampNTZType private() extends AtomicType {
*/
override def defaultSize: Int = 8
- override def typeName: String = "timestamp without time zone"
+ override def typeName: String = "timestamp_ntz"
private[spark] override def asNullable: TimestampNTZType = this
}
diff --git
a/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/expressions/CastSuiteBase.scala
b/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/expressions/CastSuiteBase.scala
index f6a628a..66f5b50 100644
---
a/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/expressions/CastSuiteBase.scala
+++
b/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/expressions/CastSuiteBase.scala
@@ -939,11 +939,11 @@ abstract class CastSuiteBase extends SparkFunSuite with
ExpressionEvalHelper {
test("disallow type conversions between Numeric types and Timestamp without
time zone type") {
import DataTypeTestUtils.numericTypes
checkInvalidCastFromNumericType(TimestampNTZType)
- var errorMsg = "cannot cast bigint to timestamp without time zone"
+ var errorMsg = "cannot cast bigint to timestamp_ntz"
verifyCastFailure(cast(Literal(0L), TimestampNTZType), Some(errorMsg))
val timestampNTZLiteral = Literal.create(LocalDateTime.now(),
TimestampNTZType)
- errorMsg = "cannot cast timestamp without time zone to"
+ errorMsg = "cannot cast timestamp_ntz to"
numericTypes.foreach { numericType =>
verifyCastFailure(cast(timestampNTZLiteral, numericType), Some(errorMsg))
}
diff --git a/sql/core/src/test/resources/sql-functions/sql-expression-schema.md
b/sql/core/src/test/resources/sql-functions/sql-expression-schema.md
index 5fa37c4..00fb172 100644
--- a/sql/core/src/test/resources/sql-functions/sql-expression-schema.md
+++ b/sql/core/src/test/resources/sql-functions/sql-expression-schema.md
@@ -206,7 +206,7 @@
| org.apache.spark.sql.catalyst.expressions.Overlay | overlay | SELECT
overlay('Spark SQL' PLACING '_' FROM 6) | struct<overlay(Spark SQL, _, 6,
-1):string> |
| org.apache.spark.sql.catalyst.expressions.ParseToDate | to_date | SELECT
to_date('2009-07-30 04:17:52') | struct<to_date(2009-07-30 04:17:52):date> |
| org.apache.spark.sql.catalyst.expressions.ParseToTimestamp | to_timestamp |
SELECT to_timestamp('2016-12-31 00:12:00') | struct<to_timestamp(2016-12-31
00:12:00):timestamp> |
-| org.apache.spark.sql.catalyst.expressions.ParseToTimestampNTZ |
to_timestamp_ntz | SELECT to_timestamp_ntz('2016-12-31 00:12:00') |
struct<to_timestamp_ntz(2016-12-31 00:12:00):timestamp without time zone> |
+| org.apache.spark.sql.catalyst.expressions.ParseToTimestampNTZ |
to_timestamp_ntz | SELECT to_timestamp_ntz('2016-12-31 00:12:00') |
struct<to_timestamp_ntz(2016-12-31 00:12:00):timestamp_ntz> |
| org.apache.spark.sql.catalyst.expressions.ParseUrl | parse_url | SELECT
parse_url('http://spark.apache.org/path?query=1', 'HOST') |
struct<parse_url(http://spark.apache.org/path?query=1, HOST):string> |
| org.apache.spark.sql.catalyst.expressions.PercentRank | percent_rank |
SELECT a, b, percent_rank(b) OVER (PARTITION BY a ORDER BY b) FROM VALUES
('A1', 2), ('A1', 1), ('A2', 3), ('A1', 1) tab(a, b) |
struct<a:string,b:int,PERCENT_RANK() OVER (PARTITION BY a ORDER BY b ASC NULLS
FIRST ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW):double> |
| org.apache.spark.sql.catalyst.expressions.Pi | pi | SELECT pi() |
struct<PI():double> |
@@ -361,4 +361,4 @@
| org.apache.spark.sql.catalyst.expressions.xml.XPathList | xpath | SELECT
xpath('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>','a/b/text()') |
struct<xpath(<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>,
a/b/text()):array<string>> |
| org.apache.spark.sql.catalyst.expressions.xml.XPathLong | xpath_long |
SELECT xpath_long('<a><b>1</b><b>2</b></a>', 'sum(a/b)') |
struct<xpath_long(<a><b>1</b><b>2</b></a>, sum(a/b)):bigint> |
| org.apache.spark.sql.catalyst.expressions.xml.XPathShort | xpath_short |
SELECT xpath_short('<a><b>1</b><b>2</b></a>', 'sum(a/b)') |
struct<xpath_short(<a><b>1</b><b>2</b></a>, sum(a/b)):smallint> |
-| org.apache.spark.sql.catalyst.expressions.xml.XPathString | xpath_string |
SELECT xpath_string('<a><b>b</b><c>cc</c></a>','a/c') |
struct<xpath_string(<a><b>b</b><c>cc</c></a>, a/c):string> |
\ No newline at end of file
+| org.apache.spark.sql.catalyst.expressions.xml.XPathString | xpath_string |
SELECT xpath_string('<a><b>b</b><c>cc</c></a>','a/c') |
struct<xpath_string(<a><b>b</b><c>cc</c></a>, a/c):string> |
diff --git
a/sql/core/src/test/resources/sql-tests/results/ansi/datetime.sql.out
b/sql/core/src/test/resources/sql-tests/results/ansi/datetime.sql.out
index 86eb1f8..d42d3f4 100644
--- a/sql/core/src/test/resources/sql-tests/results/ansi/datetime.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/ansi/datetime.sql.out
@@ -160,7 +160,7 @@ NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
-- !query
select to_timestamp_ntz(null), to_timestamp_ntz('2016-12-31 00:12:00'),
to_timestamp_ntz('2016-12-31', 'yyyy-MM-dd')
-- !query schema
-struct<to_timestamp_ntz(NULL):timestamp without time
zone,to_timestamp_ntz(2016-12-31 00:12:00):timestamp without time
zone,to_timestamp_ntz(2016-12-31, yyyy-MM-dd):timestamp without time zone>
+struct<to_timestamp_ntz(NULL):timestamp_ntz,to_timestamp_ntz(2016-12-31
00:12:00):timestamp_ntz,to_timestamp_ntz(2016-12-31, yyyy-MM-dd):timestamp_ntz>
-- !query output
NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
@@ -168,7 +168,7 @@ NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
-- !query
select to_timestamp_ntz(to_date(null)),
to_timestamp_ntz(to_date('2016-12-31')), to_timestamp_ntz(to_date('2016-12-31',
'yyyy-MM-dd'))
-- !query schema
-struct<to_timestamp_ntz(to_date(NULL)):timestamp without time
zone,to_timestamp_ntz(to_date(2016-12-31)):timestamp without time
zone,to_timestamp_ntz(to_date(2016-12-31, yyyy-MM-dd)):timestamp without time
zone>
+struct<to_timestamp_ntz(to_date(NULL)):timestamp_ntz,to_timestamp_ntz(to_date(2016-12-31)):timestamp_ntz,to_timestamp_ntz(to_date(2016-12-31,
yyyy-MM-dd)):timestamp_ntz>
-- !query output
NULL 2016-12-31 00:00:00 2016-12-31 00:00:00
@@ -176,7 +176,7 @@ NULL 2016-12-31 00:00:00 2016-12-31 00:00:00
-- !query
select to_timestamp_ntz(to_timestamp(null)),
to_timestamp_ntz(to_timestamp('2016-12-31 00:12:00')),
to_timestamp_ntz(to_timestamp('2016-12-31', 'yyyy-MM-dd'))
-- !query schema
-struct<to_timestamp_ntz(to_timestamp(NULL)):timestamp without time
zone,to_timestamp_ntz(to_timestamp(2016-12-31 00:12:00)):timestamp without time
zone,to_timestamp_ntz(to_timestamp(2016-12-31, yyyy-MM-dd)):timestamp without
time zone>
+struct<to_timestamp_ntz(to_timestamp(NULL)):timestamp_ntz,to_timestamp_ntz(to_timestamp(2016-12-31
00:12:00)):timestamp_ntz,to_timestamp_ntz(to_timestamp(2016-12-31,
yyyy-MM-dd)):timestamp_ntz>
-- !query output
NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
@@ -959,7 +959,7 @@ Text '2019-10-06 10:11:12.' could not be parsed at index 20
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.0', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.0, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.0, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -967,7 +967,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.0, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1
@@ -975,7 +975,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.1, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.12', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12
@@ -983,7 +983,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz])
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.123UTC', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.123UTC, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.123UTC, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123
@@ -991,7 +991,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.123UTC,
yyyy-MM-dd HH:mm:ss.SSSSSS[z
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1234', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1234
@@ -999,7 +999,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.1234,
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.12345CST', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.12345CST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.12345CST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12345
@@ -1007,7 +1007,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.12345CST,
yyyy-MM-dd HH:mm:ss.SSSSSS
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.123456PST', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.123456PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.123456PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123456
@@ -1024,7 +1024,7 @@ Text '2019-10-06 10:11:12.1234567PST' could not be
parsed, unparsed text found a
-- !query
select to_timestamp_ntz('123456 2019-10-06 10:11:12.123456PST', 'SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(123456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(123456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123456
@@ -1041,7 +1041,7 @@ Text '223456 2019-10-06 10:11:12.123456PST' could not be
parsed at index 27
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1234', 'yyyy-MM-dd
HH:mm:ss.[SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.[SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.[SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1234
@@ -1049,7 +1049,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.1234,
yyyy-MM-dd HH:mm:ss.[SSSSSS]):
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.123', 'yyyy-MM-dd
HH:mm:ss[.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.123, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.123, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123
@@ -1057,7 +1057,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.123,
yyyy-MM-dd HH:mm:ss[.SSSSSS]):t
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12', 'yyyy-MM-dd HH:mm:ss[.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1065,7 +1065,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):times
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.12', 'yyyy-MM-dd
HH:mm[:ss.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12
@@ -1073,7 +1073,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.12,
yyyy-MM-dd HH:mm[:ss.SSSSSS]):ti
-- !query
select to_timestamp_ntz('2019-10-06 10:11', 'yyyy-MM-dd HH:mm[:ss.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:00
@@ -1081,7 +1081,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestam
-- !query
select to_timestamp_ntz("2019-10-06S10:11:12.12345",
"yyyy-MM-dd'S'HH:mm:ss.SSSSSS")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06S10:11:12.12345,
yyyy-MM-dd'S'HH:mm:ss.SSSSSS):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06S10:11:12.12345,
yyyy-MM-dd'S'HH:mm:ss.SSSSSS):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12345
@@ -1089,7 +1089,7 @@ struct<to_timestamp_ntz(2019-10-06S10:11:12.12345,
yyyy-MM-dd'S'HH:mm:ss.SSSSSS)
-- !query
select to_timestamp_ntz("12.12342019-10-06S10:11", "ss.SSSSyyyy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.12342019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.12342019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1234
@@ -1115,7 +1115,7 @@ Text '12.1232019-10-06S10:11' could not be parsed at
index 9
-- !query
select to_timestamp_ntz("12.1234019-10-06S10:11", "ss.SSSSy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.1234019-10-06S10:11,
ss.SSSSy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.1234019-10-06S10:11,
ss.SSSSy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
0019-10-06 10:11:12.1234
@@ -1123,7 +1123,7 @@ struct<to_timestamp_ntz(12.1234019-10-06S10:11,
ss.SSSSy-MM-dd'S'HH:mm):timestam
-- !query
select to_timestamp_ntz("2019-10-06S", "yyyy-MM-dd'S'")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06S, yyyy-MM-dd'S'):timestamp without time
zone>
+struct<to_timestamp_ntz(2019-10-06S, yyyy-MM-dd'S'):timestamp_ntz>
-- !query output
2019-10-06 00:00:00
@@ -1131,7 +1131,7 @@ struct<to_timestamp_ntz(2019-10-06S,
yyyy-MM-dd'S'):timestamp without time zone>
-- !query
select to_timestamp_ntz("S2019-10-06", "'S'yyyy-MM-dd")
-- !query schema
-struct<to_timestamp_ntz(S2019-10-06, 'S'yyyy-MM-dd):timestamp without time
zone>
+struct<to_timestamp_ntz(S2019-10-06, 'S'yyyy-MM-dd):timestamp_ntz>
-- !query output
2019-10-06 00:00:00
@@ -1139,7 +1139,7 @@ struct<to_timestamp_ntz(S2019-10-06,
'S'yyyy-MM-dd):timestamp without time zone>
-- !query
select to_timestamp_ntz("2019-10-06T10:11:12'12",
"yyyy-MM-dd'T'HH:mm:ss''SSSS")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06T10:11:12'12,
yyyy-MM-dd'T'HH:mm:ss''SSSS):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06T10:11:12'12,
yyyy-MM-dd'T'HH:mm:ss''SSSS):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12
@@ -1147,7 +1147,7 @@ struct<to_timestamp_ntz(2019-10-06T10:11:12'12,
yyyy-MM-dd'T'HH:mm:ss''SSSS):tim
-- !query
select to_timestamp_ntz("2019-10-06T10:11:12'", "yyyy-MM-dd'T'HH:mm:ss''")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06T10:11:12',
yyyy-MM-dd'T'HH:mm:ss''):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06T10:11:12',
yyyy-MM-dd'T'HH:mm:ss''):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1155,7 +1155,7 @@ struct<to_timestamp_ntz(2019-10-06T10:11:12',
yyyy-MM-dd'T'HH:mm:ss''):timestamp
-- !query
select to_timestamp_ntz("'2019-10-06T10:11:12", "''yyyy-MM-dd'T'HH:mm:ss")
-- !query schema
-struct<to_timestamp_ntz('2019-10-06T10:11:12,
''yyyy-MM-dd'T'HH:mm:ss):timestamp without time zone>
+struct<to_timestamp_ntz('2019-10-06T10:11:12,
''yyyy-MM-dd'T'HH:mm:ss):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1163,7 +1163,7 @@ struct<to_timestamp_ntz('2019-10-06T10:11:12,
''yyyy-MM-dd'T'HH:mm:ss):timestamp
-- !query
select to_timestamp_ntz("P2019-10-06T10:11:12", "'P'yyyy-MM-dd'T'HH:mm:ss")
-- !query schema
-struct<to_timestamp_ntz(P2019-10-06T10:11:12,
'P'yyyy-MM-dd'T'HH:mm:ss):timestamp without time zone>
+struct<to_timestamp_ntz(P2019-10-06T10:11:12,
'P'yyyy-MM-dd'T'HH:mm:ss):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1188,7 +1188,7 @@ Invalid date 'February 29' as '1970' is not a leap year
-- !query
select to_timestamp_ntz("16", "dd")
-- !query schema
-struct<to_timestamp_ntz(16, dd):timestamp without time zone>
+struct<to_timestamp_ntz(16, dd):timestamp_ntz>
-- !query output
1970-01-16 00:00:00
@@ -1238,7 +1238,7 @@ struct<to_timestamp(2019 10:10:10, yyyy
hh:mm:ss):timestamp>
-- !query
select to_timestamp_ntz("2019 40", "yyyy mm")
-- !query schema
-struct<to_timestamp_ntz(2019 40, yyyy mm):timestamp without time zone>
+struct<to_timestamp_ntz(2019 40, yyyy mm):timestamp_ntz>
-- !query output
2019-01-01 00:40:00
@@ -1246,7 +1246,7 @@ struct<to_timestamp_ntz(2019 40, yyyy mm):timestamp
without time zone>
-- !query
select to_timestamp_ntz("2019 10:10:10", "yyyy hh:mm:ss")
-- !query schema
-struct<to_timestamp_ntz(2019 10:10:10, yyyy hh:mm:ss):timestamp without time
zone>
+struct<to_timestamp_ntz(2019 10:10:10, yyyy hh:mm:ss):timestamp_ntz>
-- !query output
2019-01-01 10:10:10
@@ -1503,7 +1503,7 @@ NULL
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval 2 day
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '2 days':timestamp
without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '2 days':timestamp_ntz>
-- !query output
2021-06-27 10:11:12
@@ -1511,7 +1511,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'2 days':timestamp witho
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '0-0' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0-0' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0-0' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1519,7 +1519,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'0-0' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '1-2' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '1-2' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '1-2' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2022-08-25 10:11:12
@@ -1527,7 +1527,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'1-2' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '0 0:0:0' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1535,7 +1535,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'0 00:00:00' DAY TO SECO
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '0 0:0:0.1' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:12.1
@@ -1543,7 +1543,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'0 00:00:00.1' DAY TO SE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '10-9' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '10-9' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '10-9' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2032-03-25 10:11:12
@@ -1551,7 +1551,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'10-9' YEAR TO MONTH:tim
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '20 15' day to hour
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15' DAY TO
HOUR:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15' DAY TO
HOUR:timestamp_ntz>
-- !query output
2021-07-16 01:11:12
@@ -1559,7 +1559,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'20 15' DAY TO HOUR:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '20 15:40' day to
minute
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40' DAY TO
MINUTE:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40' DAY TO
MINUTE:timestamp_ntz>
-- !query output
2021-07-16 01:51:12
@@ -1567,7 +1567,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'20 15:40' DAY TO MINUTE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '20
15:40:32.99899999' day to second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp_ntz>
-- !query output
2021-07-16 01:51:44.998999
@@ -1575,7 +1575,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'20 15:40:32.998999' DAY
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval 2 day
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '2 days':timestamp
without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '2 days':timestamp_ntz>
-- !query output
2021-06-23 10:11:12
@@ -1583,7 +1583,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'2 days':timestamp witho
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '0-0' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0-0' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0-0' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1591,7 +1591,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'0-0' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '1-2' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '1-2' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '1-2' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2020-04-25 10:11:12
@@ -1599,7 +1599,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'1-2' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '0 0:0:0' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1607,7 +1607,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'0 00:00:00' DAY TO SECO
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '0 0:0:0.1' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:11.9
@@ -1615,7 +1615,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'0 00:00:00.1' DAY TO SE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '10-9' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '10-9' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '10-9' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2010-09-25 10:11:12
@@ -1623,7 +1623,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'10-9' YEAR TO MONTH:tim
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '20 15' day to hour
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15' DAY TO
HOUR:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15' DAY TO
HOUR:timestamp_ntz>
-- !query output
2021-06-04 19:11:12
@@ -1631,7 +1631,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'20 15' DAY TO HOUR:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '20 15:40' day to
minute
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40' DAY TO
MINUTE:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40' DAY TO
MINUTE:timestamp_ntz>
-- !query output
2021-06-04 18:31:12
@@ -1639,6 +1639,6 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'20 15:40' DAY TO MINUTE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '20
15:40:32.99899999' day to second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp_ntz>
-- !query output
2021-06-04 18:30:39.001001
diff --git
a/sql/core/src/test/resources/sql-tests/results/datetime-legacy.sql.out
b/sql/core/src/test/resources/sql-tests/results/datetime-legacy.sql.out
index 3ce5f02..2bf5c9f 100644
--- a/sql/core/src/test/resources/sql-tests/results/datetime-legacy.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/datetime-legacy.sql.out
@@ -154,7 +154,7 @@ NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
-- !query
select to_timestamp_ntz(null), to_timestamp_ntz('2016-12-31 00:12:00'),
to_timestamp_ntz('2016-12-31', 'yyyy-MM-dd')
-- !query schema
-struct<to_timestamp_ntz(NULL):timestamp without time
zone,to_timestamp_ntz(2016-12-31 00:12:00):timestamp without time
zone,to_timestamp_ntz(2016-12-31, yyyy-MM-dd):timestamp without time zone>
+struct<to_timestamp_ntz(NULL):timestamp_ntz,to_timestamp_ntz(2016-12-31
00:12:00):timestamp_ntz,to_timestamp_ntz(2016-12-31, yyyy-MM-dd):timestamp_ntz>
-- !query output
NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
@@ -162,7 +162,7 @@ NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
-- !query
select to_timestamp_ntz(to_date(null)),
to_timestamp_ntz(to_date('2016-12-31')), to_timestamp_ntz(to_date('2016-12-31',
'yyyy-MM-dd'))
-- !query schema
-struct<to_timestamp_ntz(to_date(NULL)):timestamp without time
zone,to_timestamp_ntz(to_date(2016-12-31)):timestamp without time
zone,to_timestamp_ntz(to_date(2016-12-31, yyyy-MM-dd)):timestamp without time
zone>
+struct<to_timestamp_ntz(to_date(NULL)):timestamp_ntz,to_timestamp_ntz(to_date(2016-12-31)):timestamp_ntz,to_timestamp_ntz(to_date(2016-12-31,
yyyy-MM-dd)):timestamp_ntz>
-- !query output
NULL 2016-12-31 00:00:00 2016-12-31 00:00:00
@@ -170,7 +170,7 @@ NULL 2016-12-31 00:00:00 2016-12-31 00:00:00
-- !query
select to_timestamp_ntz(to_timestamp(null)),
to_timestamp_ntz(to_timestamp('2016-12-31 00:12:00')),
to_timestamp_ntz(to_timestamp('2016-12-31', 'yyyy-MM-dd'))
-- !query schema
-struct<to_timestamp_ntz(to_timestamp(NULL)):timestamp without time
zone,to_timestamp_ntz(to_timestamp(2016-12-31 00:12:00)):timestamp without time
zone,to_timestamp_ntz(to_timestamp(2016-12-31, yyyy-MM-dd)):timestamp without
time zone>
+struct<to_timestamp_ntz(to_timestamp(NULL)):timestamp_ntz,to_timestamp_ntz(to_timestamp(2016-12-31
00:12:00)):timestamp_ntz,to_timestamp_ntz(to_timestamp(2016-12-31,
yyyy-MM-dd)):timestamp_ntz>
-- !query output
NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
@@ -922,7 +922,7 @@ struct<to_timestamp(P2019-10-06T10:11:12,
'P'yyyy-MM-dd'T'HH:mm:ss):timestamp>
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12., yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12., yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
NULL
@@ -930,7 +930,7 @@ NULL
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.0', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.0, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.0, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -938,7 +938,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.0, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1
@@ -946,7 +946,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.1, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.12', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12
@@ -954,7 +954,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz])
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.123UTC', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.123UTC, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.123UTC, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123
@@ -962,7 +962,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.123UTC,
yyyy-MM-dd HH:mm:ss.SSSSSS[z
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1234', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1234
@@ -970,7 +970,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.1234,
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.12345CST', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.12345CST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.12345CST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12345
@@ -978,7 +978,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.12345CST,
yyyy-MM-dd HH:mm:ss.SSSSSS
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.123456PST', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.123456PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.123456PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123456
@@ -986,7 +986,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.123456PST,
yyyy-MM-dd HH:mm:ss.SSSSS
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1234567PST', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1234567PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1234567PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
NULL
@@ -994,7 +994,7 @@ NULL
-- !query
select to_timestamp_ntz('123456 2019-10-06 10:11:12.123456PST', 'SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(123456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(123456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123456
@@ -1002,7 +1002,7 @@ struct<to_timestamp_ntz(123456 2019-10-06
10:11:12.123456PST, SSSSSS yyyy-MM-dd
-- !query
select to_timestamp_ntz('223456 2019-10-06 10:11:12.123456PST', 'SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(223456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(223456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
NULL
@@ -1010,7 +1010,7 @@ NULL
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1234', 'yyyy-MM-dd
HH:mm:ss.[SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.[SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.[SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1234
@@ -1018,7 +1018,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.1234,
yyyy-MM-dd HH:mm:ss.[SSSSSS]):
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.123', 'yyyy-MM-dd
HH:mm:ss[.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.123, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.123, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123
@@ -1026,7 +1026,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.123,
yyyy-MM-dd HH:mm:ss[.SSSSSS]):t
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12', 'yyyy-MM-dd HH:mm:ss[.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1034,7 +1034,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):times
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.12', 'yyyy-MM-dd
HH:mm[:ss.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12
@@ -1042,7 +1042,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.12,
yyyy-MM-dd HH:mm[:ss.SSSSSS]):ti
-- !query
select to_timestamp_ntz('2019-10-06 10:11', 'yyyy-MM-dd HH:mm[:ss.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:00
@@ -1050,7 +1050,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestam
-- !query
select to_timestamp_ntz("2019-10-06S10:11:12.12345",
"yyyy-MM-dd'S'HH:mm:ss.SSSSSS")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06S10:11:12.12345,
yyyy-MM-dd'S'HH:mm:ss.SSSSSS):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06S10:11:12.12345,
yyyy-MM-dd'S'HH:mm:ss.SSSSSS):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12345
@@ -1058,7 +1058,7 @@ struct<to_timestamp_ntz(2019-10-06S10:11:12.12345,
yyyy-MM-dd'S'HH:mm:ss.SSSSSS)
-- !query
select to_timestamp_ntz("12.12342019-10-06S10:11", "ss.SSSSyyyy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.12342019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.12342019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1234
@@ -1066,7 +1066,7 @@ struct<to_timestamp_ntz(12.12342019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):time
-- !query
select to_timestamp_ntz("12.1232019-10-06S10:11", "ss.SSSSyyyy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.1232019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.1232019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
NULL
@@ -1074,7 +1074,7 @@ NULL
-- !query
select to_timestamp_ntz("12.1232019-10-06S10:11", "ss.SSSSyy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.1232019-10-06S10:11,
ss.SSSSyy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.1232019-10-06S10:11,
ss.SSSSyy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
NULL
@@ -1082,7 +1082,7 @@ NULL
-- !query
select to_timestamp_ntz("12.1234019-10-06S10:11", "ss.SSSSy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.1234019-10-06S10:11,
ss.SSSSy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.1234019-10-06S10:11,
ss.SSSSy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
0019-10-06 10:11:12.1234
@@ -1090,7 +1090,7 @@ struct<to_timestamp_ntz(12.1234019-10-06S10:11,
ss.SSSSy-MM-dd'S'HH:mm):timestam
-- !query
select to_timestamp_ntz("2019-10-06S", "yyyy-MM-dd'S'")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06S, yyyy-MM-dd'S'):timestamp without time
zone>
+struct<to_timestamp_ntz(2019-10-06S, yyyy-MM-dd'S'):timestamp_ntz>
-- !query output
2019-10-06 00:00:00
@@ -1098,7 +1098,7 @@ struct<to_timestamp_ntz(2019-10-06S,
yyyy-MM-dd'S'):timestamp without time zone>
-- !query
select to_timestamp_ntz("S2019-10-06", "'S'yyyy-MM-dd")
-- !query schema
-struct<to_timestamp_ntz(S2019-10-06, 'S'yyyy-MM-dd):timestamp without time
zone>
+struct<to_timestamp_ntz(S2019-10-06, 'S'yyyy-MM-dd):timestamp_ntz>
-- !query output
2019-10-06 00:00:00
@@ -1106,7 +1106,7 @@ struct<to_timestamp_ntz(S2019-10-06,
'S'yyyy-MM-dd):timestamp without time zone>
-- !query
select to_timestamp_ntz("2019-10-06T10:11:12'12",
"yyyy-MM-dd'T'HH:mm:ss''SSSS")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06T10:11:12'12,
yyyy-MM-dd'T'HH:mm:ss''SSSS):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06T10:11:12'12,
yyyy-MM-dd'T'HH:mm:ss''SSSS):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12
@@ -1114,7 +1114,7 @@ struct<to_timestamp_ntz(2019-10-06T10:11:12'12,
yyyy-MM-dd'T'HH:mm:ss''SSSS):tim
-- !query
select to_timestamp_ntz("2019-10-06T10:11:12'", "yyyy-MM-dd'T'HH:mm:ss''")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06T10:11:12',
yyyy-MM-dd'T'HH:mm:ss''):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06T10:11:12',
yyyy-MM-dd'T'HH:mm:ss''):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1122,7 +1122,7 @@ struct<to_timestamp_ntz(2019-10-06T10:11:12',
yyyy-MM-dd'T'HH:mm:ss''):timestamp
-- !query
select to_timestamp_ntz("'2019-10-06T10:11:12", "''yyyy-MM-dd'T'HH:mm:ss")
-- !query schema
-struct<to_timestamp_ntz('2019-10-06T10:11:12,
''yyyy-MM-dd'T'HH:mm:ss):timestamp without time zone>
+struct<to_timestamp_ntz('2019-10-06T10:11:12,
''yyyy-MM-dd'T'HH:mm:ss):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1130,7 +1130,7 @@ struct<to_timestamp_ntz('2019-10-06T10:11:12,
''yyyy-MM-dd'T'HH:mm:ss):timestamp
-- !query
select to_timestamp_ntz("P2019-10-06T10:11:12", "'P'yyyy-MM-dd'T'HH:mm:ss")
-- !query schema
-struct<to_timestamp_ntz(P2019-10-06T10:11:12,
'P'yyyy-MM-dd'T'HH:mm:ss):timestamp without time zone>
+struct<to_timestamp_ntz(P2019-10-06T10:11:12,
'P'yyyy-MM-dd'T'HH:mm:ss):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1154,7 +1154,7 @@ NULL
-- !query
select to_timestamp_ntz("16", "dd")
-- !query schema
-struct<to_timestamp_ntz(16, dd):timestamp without time zone>
+struct<to_timestamp_ntz(16, dd):timestamp_ntz>
-- !query output
1970-01-16 00:00:00
@@ -1162,7 +1162,7 @@ struct<to_timestamp_ntz(16, dd):timestamp without time
zone>
-- !query
select to_timestamp_ntz("02-29", "MM-dd")
-- !query schema
-struct<to_timestamp_ntz(02-29, MM-dd):timestamp without time zone>
+struct<to_timestamp_ntz(02-29, MM-dd):timestamp_ntz>
-- !query output
NULL
@@ -1202,7 +1202,7 @@ struct<to_timestamp(2019 10:10:10, yyyy
hh:mm:ss):timestamp>
-- !query
select to_timestamp_ntz("2019 40", "yyyy mm")
-- !query schema
-struct<to_timestamp_ntz(2019 40, yyyy mm):timestamp without time zone>
+struct<to_timestamp_ntz(2019 40, yyyy mm):timestamp_ntz>
-- !query output
2019-01-01 00:40:00
@@ -1210,7 +1210,7 @@ struct<to_timestamp_ntz(2019 40, yyyy mm):timestamp
without time zone>
-- !query
select to_timestamp_ntz("2019 10:10:10", "yyyy hh:mm:ss")
-- !query schema
-struct<to_timestamp_ntz(2019 10:10:10, yyyy hh:mm:ss):timestamp without time
zone>
+struct<to_timestamp_ntz(2019 10:10:10, yyyy hh:mm:ss):timestamp_ntz>
-- !query output
2019-01-01 10:10:10
@@ -1341,7 +1341,7 @@ NULL
-- !query
select to_timestamp_ntz("2020-01-27T20:06:11.847", "yyyy-MM-dd HH:mm:ss.SSS")
-- !query schema
-struct<to_timestamp_ntz(2020-01-27T20:06:11.847, yyyy-MM-dd
HH:mm:ss.SSS):timestamp without time zone>
+struct<to_timestamp_ntz(2020-01-27T20:06:11.847, yyyy-MM-dd
HH:mm:ss.SSS):timestamp_ntz>
-- !query output
NULL
@@ -1349,7 +1349,7 @@ NULL
-- !query
select to_timestamp_ntz("Unparseable", "yyyy-MM-dd HH:mm:ss.SSS")
-- !query schema
-struct<to_timestamp_ntz(Unparseable, yyyy-MM-dd HH:mm:ss.SSS):timestamp
without time zone>
+struct<to_timestamp_ntz(Unparseable, yyyy-MM-dd HH:mm:ss.SSS):timestamp_ntz>
-- !query output
NULL
@@ -1445,7 +1445,7 @@ NULL
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval 2 day
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '2 days':timestamp
without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '2 days':timestamp_ntz>
-- !query output
2021-06-27 10:11:12
@@ -1453,7 +1453,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'2 days':timestamp witho
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '0-0' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0-0' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0-0' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1461,7 +1461,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'0-0' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '1-2' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '1-2' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '1-2' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2022-08-25 10:11:12
@@ -1469,7 +1469,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'1-2' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '0 0:0:0' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1477,7 +1477,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'0 00:00:00' DAY TO SECO
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '0 0:0:0.1' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:12.1
@@ -1485,7 +1485,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'0 00:00:00.1' DAY TO SE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '10-9' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '10-9' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '10-9' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2032-03-25 10:11:12
@@ -1493,7 +1493,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'10-9' YEAR TO MONTH:tim
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '20 15' day to hour
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15' DAY TO
HOUR:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15' DAY TO
HOUR:timestamp_ntz>
-- !query output
2021-07-16 01:11:12
@@ -1501,7 +1501,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'20 15' DAY TO HOUR:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '20 15:40' day to
minute
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40' DAY TO
MINUTE:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40' DAY TO
MINUTE:timestamp_ntz>
-- !query output
2021-07-16 01:51:12
@@ -1509,7 +1509,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'20 15:40' DAY TO MINUTE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '20
15:40:32.99899999' day to second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp_ntz>
-- !query output
2021-07-16 01:51:44.998999
@@ -1517,7 +1517,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'20 15:40:32.998999' DAY
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval 2 day
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '2 days':timestamp
without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '2 days':timestamp_ntz>
-- !query output
2021-06-23 10:11:12
@@ -1525,7 +1525,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'2 days':timestamp witho
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '0-0' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0-0' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0-0' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1533,7 +1533,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'0-0' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '1-2' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '1-2' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '1-2' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2020-04-25 10:11:12
@@ -1541,7 +1541,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'1-2' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '0 0:0:0' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1549,7 +1549,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'0 00:00:00' DAY TO SECO
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '0 0:0:0.1' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:11.9
@@ -1557,7 +1557,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'0 00:00:00.1' DAY TO SE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '10-9' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '10-9' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '10-9' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2010-09-25 10:11:12
@@ -1565,7 +1565,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'10-9' YEAR TO MONTH:tim
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '20 15' day to hour
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15' DAY TO
HOUR:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15' DAY TO
HOUR:timestamp_ntz>
-- !query output
2021-06-04 19:11:12
@@ -1573,7 +1573,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'20 15' DAY TO HOUR:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '20 15:40' day to
minute
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40' DAY TO
MINUTE:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40' DAY TO
MINUTE:timestamp_ntz>
-- !query output
2021-06-04 18:31:12
@@ -1581,6 +1581,6 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'20 15:40' DAY TO MINUTE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '20
15:40:32.99899999' day to second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp_ntz>
-- !query output
2021-06-04 18:30:39.001001
diff --git a/sql/core/src/test/resources/sql-tests/results/datetime.sql.out
b/sql/core/src/test/resources/sql-tests/results/datetime.sql.out
index 6c7115c..22dc56d 100755
--- a/sql/core/src/test/resources/sql-tests/results/datetime.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/datetime.sql.out
@@ -154,7 +154,7 @@ NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
-- !query
select to_timestamp_ntz(null), to_timestamp_ntz('2016-12-31 00:12:00'),
to_timestamp_ntz('2016-12-31', 'yyyy-MM-dd')
-- !query schema
-struct<to_timestamp_ntz(NULL):timestamp without time
zone,to_timestamp_ntz(2016-12-31 00:12:00):timestamp without time
zone,to_timestamp_ntz(2016-12-31, yyyy-MM-dd):timestamp without time zone>
+struct<to_timestamp_ntz(NULL):timestamp_ntz,to_timestamp_ntz(2016-12-31
00:12:00):timestamp_ntz,to_timestamp_ntz(2016-12-31, yyyy-MM-dd):timestamp_ntz>
-- !query output
NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
@@ -162,7 +162,7 @@ NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
-- !query
select to_timestamp_ntz(to_date(null)),
to_timestamp_ntz(to_date('2016-12-31')), to_timestamp_ntz(to_date('2016-12-31',
'yyyy-MM-dd'))
-- !query schema
-struct<to_timestamp_ntz(to_date(NULL)):timestamp without time
zone,to_timestamp_ntz(to_date(2016-12-31)):timestamp without time
zone,to_timestamp_ntz(to_date(2016-12-31, yyyy-MM-dd)):timestamp without time
zone>
+struct<to_timestamp_ntz(to_date(NULL)):timestamp_ntz,to_timestamp_ntz(to_date(2016-12-31)):timestamp_ntz,to_timestamp_ntz(to_date(2016-12-31,
yyyy-MM-dd)):timestamp_ntz>
-- !query output
NULL 2016-12-31 00:00:00 2016-12-31 00:00:00
@@ -170,7 +170,7 @@ NULL 2016-12-31 00:00:00 2016-12-31 00:00:00
-- !query
select to_timestamp_ntz(to_timestamp(null)),
to_timestamp_ntz(to_timestamp('2016-12-31 00:12:00')),
to_timestamp_ntz(to_timestamp('2016-12-31', 'yyyy-MM-dd'))
-- !query schema
-struct<to_timestamp_ntz(to_timestamp(NULL)):timestamp without time
zone,to_timestamp_ntz(to_timestamp(2016-12-31 00:12:00)):timestamp without time
zone,to_timestamp_ntz(to_timestamp(2016-12-31, yyyy-MM-dd)):timestamp without
time zone>
+struct<to_timestamp_ntz(to_timestamp(NULL)):timestamp_ntz,to_timestamp_ntz(to_timestamp(2016-12-31
00:12:00)):timestamp_ntz,to_timestamp_ntz(to_timestamp(2016-12-31,
yyyy-MM-dd)):timestamp_ntz>
-- !query output
NULL 2016-12-31 00:12:00 2016-12-31 00:00:00
@@ -922,7 +922,7 @@ struct<to_timestamp(P2019-10-06T10:11:12,
'P'yyyy-MM-dd'T'HH:mm:ss):timestamp>
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12., yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12., yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
NULL
@@ -930,7 +930,7 @@ NULL
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.0', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.0, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.0, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -938,7 +938,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.0, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1
@@ -946,7 +946,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.1, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.12', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12
@@ -954,7 +954,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz])
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.123UTC', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.123UTC, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.123UTC, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123
@@ -962,7 +962,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.123UTC,
yyyy-MM-dd HH:mm:ss.SSSSSS[z
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1234', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1234
@@ -970,7 +970,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.1234,
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.12345CST', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.12345CST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.12345CST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12345
@@ -978,7 +978,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.12345CST,
yyyy-MM-dd HH:mm:ss.SSSSSS
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.123456PST', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.123456PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.123456PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123456
@@ -986,7 +986,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.123456PST,
yyyy-MM-dd HH:mm:ss.SSSSS
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1234567PST', 'yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1234567PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1234567PST, yyyy-MM-dd
HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
NULL
@@ -994,7 +994,7 @@ NULL
-- !query
select to_timestamp_ntz('123456 2019-10-06 10:11:12.123456PST', 'SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(123456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(123456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123456
@@ -1002,7 +1002,7 @@ struct<to_timestamp_ntz(123456 2019-10-06
10:11:12.123456PST, SSSSSS yyyy-MM-dd
-- !query
select to_timestamp_ntz('223456 2019-10-06 10:11:12.123456PST', 'SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]')
-- !query schema
-struct<to_timestamp_ntz(223456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp without time zone>
+struct<to_timestamp_ntz(223456 2019-10-06 10:11:12.123456PST, SSSSSS
yyyy-MM-dd HH:mm:ss.SSSSSS[zzz]):timestamp_ntz>
-- !query output
NULL
@@ -1010,7 +1010,7 @@ NULL
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.1234', 'yyyy-MM-dd
HH:mm:ss.[SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.[SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.1234, yyyy-MM-dd
HH:mm:ss.[SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1234
@@ -1018,7 +1018,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.1234,
yyyy-MM-dd HH:mm:ss.[SSSSSS]):
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.123', 'yyyy-MM-dd
HH:mm:ss[.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.123, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.123, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.123
@@ -1026,7 +1026,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.123,
yyyy-MM-dd HH:mm:ss[.SSSSSS]):t
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12', 'yyyy-MM-dd HH:mm:ss[.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1034,7 +1034,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12, yyyy-MM-dd
HH:mm:ss[.SSSSSS]):times
-- !query
select to_timestamp_ntz('2019-10-06 10:11:12.12', 'yyyy-MM-dd
HH:mm[:ss.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11:12.12, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12
@@ -1042,7 +1042,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11:12.12,
yyyy-MM-dd HH:mm[:ss.SSSSSS]):ti
-- !query
select to_timestamp_ntz('2019-10-06 10:11', 'yyyy-MM-dd HH:mm[:ss.SSSSSS]')
-- !query schema
-struct<to_timestamp_ntz(2019-10-06 10:11, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06 10:11, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestamp_ntz>
-- !query output
2019-10-06 10:11:00
@@ -1050,7 +1050,7 @@ struct<to_timestamp_ntz(2019-10-06 10:11, yyyy-MM-dd
HH:mm[:ss.SSSSSS]):timestam
-- !query
select to_timestamp_ntz("2019-10-06S10:11:12.12345",
"yyyy-MM-dd'S'HH:mm:ss.SSSSSS")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06S10:11:12.12345,
yyyy-MM-dd'S'HH:mm:ss.SSSSSS):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06S10:11:12.12345,
yyyy-MM-dd'S'HH:mm:ss.SSSSSS):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12345
@@ -1058,7 +1058,7 @@ struct<to_timestamp_ntz(2019-10-06S10:11:12.12345,
yyyy-MM-dd'S'HH:mm:ss.SSSSSS)
-- !query
select to_timestamp_ntz("12.12342019-10-06S10:11", "ss.SSSSyyyy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.12342019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.12342019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.1234
@@ -1066,7 +1066,7 @@ struct<to_timestamp_ntz(12.12342019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):time
-- !query
select to_timestamp_ntz("12.1232019-10-06S10:11", "ss.SSSSyyyy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.1232019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.1232019-10-06S10:11,
ss.SSSSyyyy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
NULL
@@ -1074,7 +1074,7 @@ NULL
-- !query
select to_timestamp_ntz("12.1232019-10-06S10:11", "ss.SSSSyy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.1232019-10-06S10:11,
ss.SSSSyy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.1232019-10-06S10:11,
ss.SSSSyy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
NULL
@@ -1082,7 +1082,7 @@ NULL
-- !query
select to_timestamp_ntz("12.1234019-10-06S10:11", "ss.SSSSy-MM-dd'S'HH:mm")
-- !query schema
-struct<to_timestamp_ntz(12.1234019-10-06S10:11,
ss.SSSSy-MM-dd'S'HH:mm):timestamp without time zone>
+struct<to_timestamp_ntz(12.1234019-10-06S10:11,
ss.SSSSy-MM-dd'S'HH:mm):timestamp_ntz>
-- !query output
0019-10-06 10:11:12.1234
@@ -1090,7 +1090,7 @@ struct<to_timestamp_ntz(12.1234019-10-06S10:11,
ss.SSSSy-MM-dd'S'HH:mm):timestam
-- !query
select to_timestamp_ntz("2019-10-06S", "yyyy-MM-dd'S'")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06S, yyyy-MM-dd'S'):timestamp without time
zone>
+struct<to_timestamp_ntz(2019-10-06S, yyyy-MM-dd'S'):timestamp_ntz>
-- !query output
2019-10-06 00:00:00
@@ -1098,7 +1098,7 @@ struct<to_timestamp_ntz(2019-10-06S,
yyyy-MM-dd'S'):timestamp without time zone>
-- !query
select to_timestamp_ntz("S2019-10-06", "'S'yyyy-MM-dd")
-- !query schema
-struct<to_timestamp_ntz(S2019-10-06, 'S'yyyy-MM-dd):timestamp without time
zone>
+struct<to_timestamp_ntz(S2019-10-06, 'S'yyyy-MM-dd):timestamp_ntz>
-- !query output
2019-10-06 00:00:00
@@ -1106,7 +1106,7 @@ struct<to_timestamp_ntz(S2019-10-06,
'S'yyyy-MM-dd):timestamp without time zone>
-- !query
select to_timestamp_ntz("2019-10-06T10:11:12'12",
"yyyy-MM-dd'T'HH:mm:ss''SSSS")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06T10:11:12'12,
yyyy-MM-dd'T'HH:mm:ss''SSSS):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06T10:11:12'12,
yyyy-MM-dd'T'HH:mm:ss''SSSS):timestamp_ntz>
-- !query output
2019-10-06 10:11:12.12
@@ -1114,7 +1114,7 @@ struct<to_timestamp_ntz(2019-10-06T10:11:12'12,
yyyy-MM-dd'T'HH:mm:ss''SSSS):tim
-- !query
select to_timestamp_ntz("2019-10-06T10:11:12'", "yyyy-MM-dd'T'HH:mm:ss''")
-- !query schema
-struct<to_timestamp_ntz(2019-10-06T10:11:12',
yyyy-MM-dd'T'HH:mm:ss''):timestamp without time zone>
+struct<to_timestamp_ntz(2019-10-06T10:11:12',
yyyy-MM-dd'T'HH:mm:ss''):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1122,7 +1122,7 @@ struct<to_timestamp_ntz(2019-10-06T10:11:12',
yyyy-MM-dd'T'HH:mm:ss''):timestamp
-- !query
select to_timestamp_ntz("'2019-10-06T10:11:12", "''yyyy-MM-dd'T'HH:mm:ss")
-- !query schema
-struct<to_timestamp_ntz('2019-10-06T10:11:12,
''yyyy-MM-dd'T'HH:mm:ss):timestamp without time zone>
+struct<to_timestamp_ntz('2019-10-06T10:11:12,
''yyyy-MM-dd'T'HH:mm:ss):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1130,7 +1130,7 @@ struct<to_timestamp_ntz('2019-10-06T10:11:12,
''yyyy-MM-dd'T'HH:mm:ss):timestamp
-- !query
select to_timestamp_ntz("P2019-10-06T10:11:12", "'P'yyyy-MM-dd'T'HH:mm:ss")
-- !query schema
-struct<to_timestamp_ntz(P2019-10-06T10:11:12,
'P'yyyy-MM-dd'T'HH:mm:ss):timestamp without time zone>
+struct<to_timestamp_ntz(P2019-10-06T10:11:12,
'P'yyyy-MM-dd'T'HH:mm:ss):timestamp_ntz>
-- !query output
2019-10-06 10:11:12
@@ -1154,7 +1154,7 @@ NULL
-- !query
select to_timestamp_ntz("16", "dd")
-- !query schema
-struct<to_timestamp_ntz(16, dd):timestamp without time zone>
+struct<to_timestamp_ntz(16, dd):timestamp_ntz>
-- !query output
1970-01-16 00:00:00
@@ -1162,7 +1162,7 @@ struct<to_timestamp_ntz(16, dd):timestamp without time
zone>
-- !query
select to_timestamp_ntz("02-29", "MM-dd")
-- !query schema
-struct<to_timestamp_ntz(02-29, MM-dd):timestamp without time zone>
+struct<to_timestamp_ntz(02-29, MM-dd):timestamp_ntz>
-- !query output
NULL
@@ -1202,7 +1202,7 @@ struct<to_timestamp(2019 10:10:10, yyyy
hh:mm:ss):timestamp>
-- !query
select to_timestamp_ntz("2019 40", "yyyy mm")
-- !query schema
-struct<to_timestamp_ntz(2019 40, yyyy mm):timestamp without time zone>
+struct<to_timestamp_ntz(2019 40, yyyy mm):timestamp_ntz>
-- !query output
2019-01-01 00:40:00
@@ -1210,7 +1210,7 @@ struct<to_timestamp_ntz(2019 40, yyyy mm):timestamp
without time zone>
-- !query
select to_timestamp_ntz("2019 10:10:10", "yyyy hh:mm:ss")
-- !query schema
-struct<to_timestamp_ntz(2019 10:10:10, yyyy hh:mm:ss):timestamp without time
zone>
+struct<to_timestamp_ntz(2019 10:10:10, yyyy hh:mm:ss):timestamp_ntz>
-- !query output
2019-01-01 10:10:10
@@ -1349,7 +1349,7 @@ NULL
-- !query
select to_timestamp_ntz("2020-01-27T20:06:11.847", "yyyy-MM-dd HH:mm:ss.SSS")
-- !query schema
-struct<to_timestamp_ntz(2020-01-27T20:06:11.847, yyyy-MM-dd
HH:mm:ss.SSS):timestamp without time zone>
+struct<to_timestamp_ntz(2020-01-27T20:06:11.847, yyyy-MM-dd
HH:mm:ss.SSS):timestamp_ntz>
-- !query output
NULL
@@ -1357,7 +1357,7 @@ NULL
-- !query
select to_timestamp_ntz("Unparseable", "yyyy-MM-dd HH:mm:ss.SSS")
-- !query schema
-struct<to_timestamp_ntz(Unparseable, yyyy-MM-dd HH:mm:ss.SSS):timestamp
without time zone>
+struct<to_timestamp_ntz(Unparseable, yyyy-MM-dd HH:mm:ss.SSS):timestamp_ntz>
-- !query output
NULL
@@ -1453,7 +1453,7 @@ NULL
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval 2 day
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '2 days':timestamp
without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '2 days':timestamp_ntz>
-- !query output
2021-06-27 10:11:12
@@ -1461,7 +1461,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'2 days':timestamp witho
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '0-0' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0-0' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0-0' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1469,7 +1469,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'0-0' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '1-2' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '1-2' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '1-2' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2022-08-25 10:11:12
@@ -1477,7 +1477,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'1-2' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '0 0:0:0' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1485,7 +1485,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'0 00:00:00' DAY TO SECO
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '0 0:0:0.1' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:12.1
@@ -1493,7 +1493,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'0 00:00:00.1' DAY TO SE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '10-9' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '10-9' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '10-9' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2032-03-25 10:11:12
@@ -1501,7 +1501,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'10-9' YEAR TO MONTH:tim
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '20 15' day to hour
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15' DAY TO
HOUR:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15' DAY TO
HOUR:timestamp_ntz>
-- !query output
2021-07-16 01:11:12
@@ -1509,7 +1509,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'20 15' DAY TO HOUR:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '20 15:40' day to
minute
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40' DAY TO
MINUTE:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40' DAY TO
MINUTE:timestamp_ntz>
-- !query output
2021-07-16 01:51:12
@@ -1517,7 +1517,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'20 15:40' DAY TO MINUTE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') + interval '20
15:40:32.99899999' day to second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp_ntz>
-- !query output
2021-07-16 01:51:44.998999
@@ -1525,7 +1525,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) + INTERVAL
'20 15:40:32.998999' DAY
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval 2 day
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '2 days':timestamp
without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '2 days':timestamp_ntz>
-- !query output
2021-06-23 10:11:12
@@ -1533,7 +1533,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'2 days':timestamp witho
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '0-0' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0-0' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0-0' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1541,7 +1541,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'0-0' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '1-2' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '1-2' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '1-2' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2020-04-25 10:11:12
@@ -1549,7 +1549,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'1-2' YEAR TO MONTH:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '0 0:0:0' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:12
@@ -1557,7 +1557,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'0 00:00:00' DAY TO SECO
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '0 0:0:0.1' day to
second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '0 00:00:00.1' DAY TO
SECOND:timestamp_ntz>
-- !query output
2021-06-25 10:11:11.9
@@ -1565,7 +1565,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'0 00:00:00.1' DAY TO SE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '10-9' year to month
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '10-9' YEAR TO
MONTH:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '10-9' YEAR TO
MONTH:timestamp_ntz>
-- !query output
2010-09-25 10:11:12
@@ -1573,7 +1573,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'10-9' YEAR TO MONTH:tim
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '20 15' day to hour
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15' DAY TO
HOUR:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15' DAY TO
HOUR:timestamp_ntz>
-- !query output
2021-06-04 19:11:12
@@ -1581,7 +1581,7 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'20 15' DAY TO HOUR:time
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '20 15:40' day to
minute
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40' DAY TO
MINUTE:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40' DAY TO
MINUTE:timestamp_ntz>
-- !query output
2021-06-04 18:31:12
@@ -1589,6 +1589,6 @@ struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL
'20 15:40' DAY TO MINUTE
-- !query
select to_timestamp_ntz('2021-06-25 10:11:12') - interval '20
15:40:32.99899999' day to second
-- !query schema
-struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp without time zone>
+struct<to_timestamp_ntz(2021-06-25 10:11:12) - INTERVAL '20 15:40:32.998999'
DAY TO SECOND:timestamp_ntz>
-- !query output
2021-06-04 18:30:39.001001
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org
For additional commands, e-mail: commits-h...@spark.apache.org
