#DateForumTypeThreadPost
213 Aug 2009 @ 12:17 PDTDatabaseReplyPartitioned column value.below query should meet UR requirement SELECT substr(ConstraintText, 17, index(ConstraintText,'BETWEEN') -17 ) FROM DBC.IndexConstraints t WHERE ConstraintType = 'Q' AND ( SUBSTRING(Constra...
112 Aug 2009 @ 01:31 PDTGeneralReplyHandling Gaps in Date Ranges.I believe below approach should be more efficient. 1. get all valid begin dates ...