Re: Question on Partition key

2023-09-02 Thread Erik Wienhold
On 03/09/2023 00:35 CEST veem v wrote: > We are trying to create a monthly range partition table , partitioned on > column PART_DATE. This will hold Orders and part_date is nothing but invoice > date. Some Team mates are asking to use the "PART_DATE" column as data type > "INTEGER" with "MM" 

Question on Partition key

2023-09-02 Thread veem v
Hello Friends, We are trying to create a monthly range partition table , partitioned on column PART_DATE. This will hold Orders and part_date is nothing but invoice date. Some Team mates are asking to use the "PART_DATE" column as data type "INTEGER" with "MM" format and also define partitions