modules/sql-engine/src/integrationTest/sql/group1/cast/test_cast_date.test

# name: test/sql/cast/test_cast_real.test
# description: CAST DATE
# feature: SQL F201(CAST function)
# group: [cast]

query T
SELECT CAST('1992-01-01' AS DATE);
----
1992-01-01

query T
SELECT CAST('1992-01-01'::DATE AS DATE);
----
1992-01-01

query T
SELECT CAST('1992-01-01'::VARCHAR AS DATE);
----
1992-01-01

query T
SELECT CAST('1992-01-01'::CHAR(10) AS DATE);
----
1992-01-01

query T
SELECT CAST('1992-01-01 00:00:00'::TIMESTAMP AS DATE);
----
1992-01-01

statement error: Cast function cannot convert value of type TIME(0) to type DATE
SELECT CAST('00:00:00'::TIME AS DATE);

statement error: Cast function cannot convert value of type BOOLEAN to type DATE
SELECT CAST(TRUE AS DATE);

statement error: Cast function cannot convert value of type TINYINT to type DATE
SELECT CAST(1::TINYINT AS DATE);

statement error: Cast function cannot convert value of type SMALLINT to type DATE
SELECT CAST(1::SMALLINT AS DATE);

statement error: Cast function cannot convert value of type INTEGER to type DATE
SELECT CAST(1::INT AS DATE);

statement error: Cast function cannot convert value of type BIGINT to type DATE
SELECT CAST(1::BIGINT AS DATE);

statement error: Cast function cannot convert value of type REAL to type DATE
SELECT CAST(1.0::REAL AS DATE);

statement error: Cast function cannot convert value of type FLOAT to type DATE
SELECT CAST(1.0::FLOAT AS DATE);

statement error: Cast function cannot convert value of type DOUBLE to type DATE
SELECT CAST(1.0::DOUBLE AS DATE);

statement error: Cast function cannot convert value of type  DECIMAL(5, 0) to type DATE
SELECT CAST(1::DECIMAL(5) AS DATE);

statement error: Cast function cannot convert value of type DECIMAL(5, 2) to type DATE
SELECT CAST(1::DECIMAL(5, 2) AS DATE);

statement error: Cast function cannot convert value of type UUID to type DATE
SELECT CAST('c4a0327c-44be-416d-ae90-75c05079789f'::UUID AS DATE);

statement error: Cast function cannot convert value of type VARBINARY to type DATE
SELECT CAST(x'00'::VARBINARY AS DATE);

statement error: Cast function cannot convert value of type BINARY(1) to type DATE
SELECT CAST(x'00'::BINARY AS DATE);