modules/calcite/src/test/sql/function/date/test_date_part.test

# name: test/sql/function/date/test_date_part.test
# description: DATE_PART test
# group: [date]

statement ok
CREATE TABLE dates(d DATE, s VARCHAR);

statement ok
INSERT INTO dates VALUES ('1992-01-01', 'year'), ('1992-03-03', 'month'), ('1992-05-05', 'day');


#  last_day
query TTT
SELECT LAST_DAY(DATE '1900-02-12'), LAST_DAY(DATE '1992-02-12'), LAST_DAY(DATE '2000-02-12');
----
1900-02-28	1992-02-29	2000-02-29

query T
SELECT LAST_DAY(d) FROM dates ORDER BY d;
----
1992-01-31
1992-03-31
1992-05-31

query T
SELECT LAST_DAY(d::timestamp) FROM dates ORDER BY d;
----
1992-01-31
1992-03-31
1992-05-31

#  monthname
query T
SELECT MONTHNAME(d) FROM dates ORDER BY d;
----
January
March
May

#  dayname
query T
SELECT DAYNAME(d) FROM dates ORDER BY d;
----
Wednesday
Tuesday
Tuesday

#  aliases
query I
SELECT DAYOFMONTH(d) FROM dates ORDER BY d;
----
1
3
5

query I
SELECT DAYOFWEEK(d) FROM dates ORDER BY d;
----
4
3
3