When trying to add data through the data gird, a data column cannot be set to the year 9999. The date cannot be manually typed in and can only be selected through the gui that scrolls through the years. Starting from the current year, it needs to be scrolled all the way to 9998, where is stops and cannot be scrolled further to the year 9999.
Limit on the date field is set to 9998.
WORKAROUND:
Manually run an INSERTS statement that adds the desired 9999 year.
STATUS:
Enhancement request ST67871 has been submitted to Development for consideration in a future release of Toad for Data Analysts.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center