Example 1:
select ResolvedCurrent_date,ConstraintText from DBC.PartitioningConstraintsV p
where p.databasename||'.'||p.tablename='ITCntlLoadReadyT.LR_DISTRIBUTION_EVENT_PIECE';
ResolvedCurrent_Date
2018-05-14
ConstraintText
CHECK (/*02 08 00*/ RANGE_N(Event_Dt_DD BETWEEN ((ADD_MONTHS((DATE ),(-24 )))- (EXTRACT(DAY FROM (ADD_MONTHS((DATE ),(-24 ))))( TITLE 'Day')( TITLE 'Day')( TITLE 'Day')))- (((((ADD_MONTHS((DATE ),(-24 )))- (EXTRACT(DAY FROM (ADD_MONTHS((DATE ),(-24 ))))( TITLE 'Day')( TITLE 'Day')( TITLE 'Day'))(DATE))- (10106 (DATE))) MOD 7 )- 1 ( TITLE 'DayOfWeek()')) AND (((ADD_MONTHS((DATE ),(2 )))- (EXTRACT(DAY FROM (ADD_MONTHS((DATE ),(2 ))))( TITLE 'Day')( TITLE 'Day')))- (((((ADD_MONTHS((DATE ),(2 )))- (EXTRACT(DAY FROM (ADD_MONTHS((DATE ),(2 ))))( TITLE 'Day')( TITLE 'Day'))(DATE))- (10106 (DATE))) MOD 7 )+ 1 ( TITLE 'DayOfWeek()')))+ 1 EACH INTERVAL '7' DAY ) /*1 130+3687873665275687*/ IS NOT NULL AND RANGE_N(Location_Seq_Num BETWEEN 1 AND 2500 EACH 1 ,
NO RANGE OR UNKNOWN) /*2 2501+0*/ IS NOT NULL)
Replace DATE with ReolvedCurrent_Date (Don't forget to replace "AND" with "," )
SELECT
((ADD_MONTHS((DATE '2018-05-14'),(-24 )))- (EXTRACT(DAY FROM (ADD_MONTHS((DATE '2018-05-14'),(-24 ))))( TITLE 'Day')( TITLE 'Day')( TITLE 'Day')))- (((((ADD_MONTHS((DATE '2018-05-14'),(-24 )))- (EXTRACT(DAY FROM (ADD_MONTHS((DATE '2018-05-14'),(-24 ))))( TITLE 'Day')( TITLE 'Day')( TITLE 'Day'))(DATE))- (10106 (DATE))) MOD 7 )- 1 ( TITLE 'DayOfWeek()'))
,
(((ADD_MONTHS((DATE '2018-05-14'),(2 )))- (EXTRACT(DAY FROM (ADD_MONTHS((DATE '2018-05-14'),(2 ))))( TITLE 'Day')( TITLE 'Day')))- (((((ADD_MONTHS((DATE '2018-05-14'),(2 )))- (EXTRACT(DAY FROM (ADD_MONTHS((DATE '2018-05-14'),(2 ))))( TITLE 'Day')( TITLE 'Day'))(DATE))- (10106 (DATE))) MOD 7 )+ 1 ( TITLE 'DayOfWeek()')))+ 1;
((ADD_MONTHS(2018-05-14, -24)-Day)-DayOfWeek())
2016-04-25
(((ADD_MONTHS(2018-05-14, 2)-Day)-DayOfWeek())+1)
2018-06-24
Example 2:
select ResolvedCurrent_date,ConstraintText from DBC.PartitioningConstraintsV p
where p.databasename||'.'||p.tablename='ITADST.CL_BASKET_TOTAL_A';
ResolvedCurrent_Date
2018-05-01
ConstraintText
CHECK (/*02*/ RANGE_N(Tran_Dt BETWEEN ADD_MONTHS((DATE - (CAST(((EXTRACT(DAY FROM (DATE )))- 1 ) AS INTERVAL DAY(2)))),(-13 )) AND (ADD_MONTHS((DATE - (CAST(((EXTRACT(DAY FROM (DATE )))- 1 ) AS INTERVAL DAY(2)))),(1 )))- INTERVAL '1' DAY EACH INTERVAL '1' MONTH ) IS NOT NULL AND RANGE_N(Store_Seq_Num BETWEEN 1 AND 1000 EACH 1 , NO RANGE OR UNKNOWN) IS NOT NULL )
Replace DATE with ReolvedCurrent_Date (Don't forget to replace "AND" with "," )
SELECT
ADD_MONTHS((DATE '2018-05-01' - (CAST(((EXTRACT(DAY FROM (DATE '2018-05-01' )))- 1 ) AS INTERVAL DAY(2)))),(-13 ))
,
(ADD_MONTHS((DATE '2018-05-01' - (CAST(((EXTRACT(DAY FROM (DATE '2018-05-01' )))- 1 ) AS INTERVAL DAY(2)))),(1 )))- INTERVAL '1' DAY;
ADD_MONTHS((2018-05-01-(EXTRACT(DAY FROM 2018-05-01)-1)), -13)
2017-04-01
(ADD_MONTHS((2018-05-01-(EXTRACT(DAY FROM 2018-05-01)-1)), 1)- 1)
2018-05-31