Interval data type not displayed in SQLDeveloper

If you select an interval data type column from a table or simply do math on two timestamp columns, the data is not displayed in SQLDeveloper. I guess this is a similar issue as the dbms_session.set_nls I blogged about.
There’s a related thread at OTN SQL Developer forum as well.
Of course, the workaround is to_char. Reiterate my comment. I don’t dispute that to_char should be used in production code when needed, but that doesn’t give SQLDeveloper an excuse for not doing the right thing in the first place. It may be just an additional query of v$nls_parameters.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: