aboutsummaryrefslogtreecommitdiff
path: root/sql/hive/src/test/resources/golden/udf_day-1-87168babe1110fe4c38269843414ca4
diff options
context:
space:
mode:
Diffstat (limited to 'sql/hive/src/test/resources/golden/udf_day-1-87168babe1110fe4c38269843414ca4')
-rw-r--r--sql/hive/src/test/resources/golden/udf_day-1-87168babe1110fe4c38269843414ca411
1 files changed, 7 insertions, 4 deletions
diff --git a/sql/hive/src/test/resources/golden/udf_day-1-87168babe1110fe4c38269843414ca4 b/sql/hive/src/test/resources/golden/udf_day-1-87168babe1110fe4c38269843414ca4
index 6135aafa50..7c0ec1dc3b 100644
--- a/sql/hive/src/test/resources/golden/udf_day-1-87168babe1110fe4c38269843414ca4
+++ b/sql/hive/src/test/resources/golden/udf_day-1-87168babe1110fe4c38269843414ca4
@@ -1,6 +1,9 @@
-day(date) - Returns the date of the month of date
+day(param) - Returns the day of the month of date/timestamp, or day component of interval
Synonyms: dayofmonth
-date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
-Example:
- > SELECT day('2009-30-07', 1) FROM src LIMIT 1;
+param can be one of:
+1. A string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
+2. A date value
+3. A timestamp value
+4. A day-time interval valueExample:
+ > SELECT day('2009-07-30') FROM src LIMIT 1;
30