MIN_PART_DATE function finds the minimum value for the specified partition column of type DATE.
Syntax:
MIN_PART_DATE([db_name.]table_name [, column_name [, part_col=filter, ...]]);
Parameters:
| Parameter | Type | Value | Description |
| [dbname.]table_name | VARCHAR | Identifier, variable or expression | Table name |
| column_name | VARCHAR | Identifier, variable or expression | Partition column name |
| part_col=filter | Partition filter |
Notes:
Return Value:
Return Type:
DATE.
Example 1:
Table db.orders is partitioned by local_date and has the following partitions:
| local_date=2014-12-02 |
| local_date=2014-12-03 |
| local_date=2014-12-04 |
Find the minimum value of the partition:
MIN_PART_DATE(db.orders);
Result: 2014-12-02
Example 2:
Table db.sales is partitioned by country and local_date and has the following partitions:
| country=US/local_date=2014-12-02 |
| country=US/local_date=2014-12-03 |
| country=UK/local_date=2014-12-04 |
Find the minimum value for local_date partition column for country US:
MIN_PARTITION_DATE(db.sales, local_date, country='US');
Result: 2014-12-02
Compatibility: PL/HQL extension.
Version: PL/HQL 0.01
See also: