Archives of the TeradataForum
Message Posted: Fri, 18 Oct 2013 @ 19:42:16 GMT
Unfortunately it does not cover all of my cases. For example,
- When multiple "between" clauses are present in PPI constraint. Your query will show the startdate and end date for first "between" clause only.
- When dates are stored/partitioned as integer.
- When PPI constraint is too complex to break as date. For example DATE + ADD_MONTH(25) etc.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|