- Apache Drill - Home
- Apache Drill - Introduction
- Apache Drill - Fundamentals
- Apache Drill - Architecture
- Apache Drill - Installation
- Apache Drill - SQL Operations
- Apache Drill - Query using JSON
- Window Functions using JSON
- Querying Complex Data
- Data Definition Statements
- Apache Drill - Querying Data
- Querying Data using HBase
- Querying Data using Hive
- Apache Drill - Querying Parquet Files
- Apache Drill - JDBC Interface
- Apache Drill - Custom Function
- Apache Drill - Contributors
Apache Drill - Date Time DATE_SUB(x,y)
The following program shows the query for this function −
Query
0: jdbc:drill:zk = local> select date_sub('2016-04-07',2) from (values(1));
Result
+-+ | EXPR$0 | +-+ | 2016-04-05 | +-+
The output indicates 2 days subtracted from the specified day.
apache_drill_sql_operations.htm
Advertisements