Toad World® Forums

DATE length specified as 7 (seven). Why?


#1

I create a simple table with a column data type DATE.

CREATE TABLE mpa_test_table(date_column DATE);

And Nav shows a number 7 (seven) in the LENGTH column:

ScreenShot220.jpeg

What does this number mean? Where does it come from?


#2

Hi Martin,

Thanks for your report this issue, i found this issue also happen in the old version of Nav, we are still investigating for you.

And we have create a story SQLNAV-1812 for you.

Thanks,

Michael