Archives of the TeradataForum

Message Posted: Fri, 18 Oct 2013 @ 19:42:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thanks Anomy,

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.

Regards,

Ravi

	<Prev	Next>		<<First	<Prev	Next>	Last>>