Oracle DATE Column Space
Posted on 2016-11-21
I am being asked to do the following in Oracle 11gR2:
"We jsut need enough space to write the date. Right now it is set to 1, which is not sufficient. Given that Orcale captures that 11-NOV-16, please set it for sufficient space to capture the date."
I think it is not possible to change the size of a column of datatype date. As far as I know, the date datatype has a fixed size of seven. I do not know what the person requiring this means by setting this column to have sufficient space to capture the date.
The situation here is that there is data being imported into the database with what it seems to have a date format of DD-MM-YY. Can anyone help me on this one? If you need any further information, please let me know.