Oracle SQL developer?????

[EdRev]

I don't know if this forum is also for Oracle SQL developer.

I just recently installed SQL Developer (1.1.3) and
was able to "successfully" import an excel file.
On of the column (date datatype) did not import.
The date in excel file as 01-Feb-07 and the
Data Preview pane shows 39,114 (I believe serial date).

Any help will be greatly appreciated.

 

[Turkbear]

Hi,
Oracle stores its DATE types as a number ( actually a hashed number ) - When displayed it will be in the format specified by your NLS settings or as you specify with a To_Char(Datefield,'format mask') usage.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[LKBrwnDBA]

... OR ....
The NLS_DATE_FORMAT environment variable.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb