One Star

Fixed year SCD End Date (oracle)

When using the end date for an SCD field, you only have the option of putting the year in (e.g. 9999), which defaults to 01/01/9999. Would like the ability to put in mm/dd/yyyy as a number of our existing projects utilize 12/31/9999 for our SCD Type 2 fields.
One Star

Re: Fixed year SCD End Date (oracle)

yeah that's bad..
i can't specify the date i want to put in there.. only null or some year with 1/1 date..