![]() |
I want to add a selection criteria to my SQL. The user will select a 'from' and 'to' date, e.g., 11/1/2015 and 12/31/2015. The date column (jsdate) in the table is Decimal (8,0). When I look at the dates in this column it looks like 20,150,612, 20,150,609, 20,150,611, etc. I'm trying to add a selection critieria like "and cast(jsdate as date format 'm
03 Feb 2016
| 3 comments
,
|
![]() |
All of our tables have effective start and end date columns (EFF_STRT_DT, EFF_END_DT). We want to create date partitions on some of our larger tables, and our fist instinct is to create the partition on EFF_END_DT, because we set that date to '9999-21-31' to represent "active" rows in our data warehouse.
11 Aug 2014
| 8 comments
,
|