Apache Tajo - DateTime Functions-alljchome-开发者的教程家园

Apache Tajo - DateTime Functions

Apache Tajo supports the following DateTime functions.

S.No.	Function & Description
1	Returns date added by the given day value.
2	Returns date added by the given month value.
3	current_date() Returns today’s date.
4	current_time() Returns today’s time.
5	extract(century from date/timestamp) Extracts century from the given parameter.
6	extract(day from date/timestamp) Extracts day from the given parameter.
7	extract(decade from date/timestamp) Extracts decade from the given parameter.
8	extract(day dow date/timestamp) Extracts day of week from the given parameter.
9	extract(doy from date/timestamp) Extracts day of year from the given parameter.
10	select extract(hour from timestamp) Extracts hour from the given parameter.
11	select extract(isodow from timestamp) Extracts day of week from the given parameter. This is identical to dow except for Sunday. This matches the ISO 8601 day of the week numbering.
12	select extract(isoyear from date) Extracts ISO year from the specified date. ISO year may be different from the Gregorian year.
13	extract(microseconds from time) Extracts microseconds from the given parameter. The seconds field, including fractional parts, multipped by 1 000 000;
14	extract(millennium from timestamp ) Extracts millennium from the given parameter.one millennium corresponds to 1000 years. Hence, the third millennium started January 1, 2001.
15	extract(milpseconds from time) Extracts milpseconds from the given parameter.
16	extract(minute from timestamp ) Extracts minute from the given parameter.
17	extract(quarter from timestamp) Extracts quarter of the year(1 - 4) from the given parameter.
18	Extracts date field from text.
19	now() Returns current timestamp.
20	to_char(timestamp, format text) Converts timestamp to text.
21	to_date(src text, format text) Converts text to date.
22	to_timestamp(src text, format text) Converts text to timestamp.

Apache Tajo - DateTime Functions

友情链接