Apache Tajo支持以下DateTime函数.
| S.No. | Function & Description |
|---|---|
| 1 | add_days(date date or timestamp, int day Returns date added by the given day value. |
| 2 | add_months(date date or timestamp, int month) 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, multiplied 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(milliseconds from time) Extracts milliseconds 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 | date_part(field text, source date or timestamp or time) 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. |