Page 1 of 1

Oracle Date result grid format

PostPosted: Thu Dec 06, 2012 1:51 pm
by fallingdown
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

Re: Oracle Date result grid format

PostPosted: Thu Dec 06, 2012 2:01 pm
by Serge
Hello,

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 ;)