Oracle Date result grid format

Note: please leave bug reports and feature requests on

Oracle Date result grid format

Postby fallingdown » Thu Dec 06, 2012 1:51 pm

Using the new DBeaver 2.0.2. I found that the preference for the oracle DATE type format is not being applied to the DATEs in the result grid. They are using the format preference for TIMESTAMP.

Oracle 11g
Windows 7
Posts: 41
Joined: Fri Aug 10, 2012 2:43 pm

Re: Oracle Date result grid format

Postby Serge » Thu Dec 06, 2012 2:01 pm


Yep, you are right. But it is not a bug.
In fact Oracle doesn't has different DATE,TIME and TIMESTAMP datatypes. All these types are just aliases for TIMESTAMP. Very similar to Oracle NUMBER datatype (INTEGER, DOUBLE, etc are just aliases with different scale/precision settings).
I can determine scale/precision for NUBER datatype and apply appropriate formatter but at the moment I can't realize how to detemine is it just DATE or complete TIMESTAMP column. Some databases uses DATE type and stores timestamps, other uses TIMESTAMP to store only dates. In fact there should be some algorythm (at least oracle JDBC do it somehow) but I just don't yet got it.
If you have any ideas about it - please tell me ;)
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Return to Support

Who is online

Users browsing this forum: Google [Bot] and 9 guests