#257 Add support for the Oracle intervalds datatype

General
open
nobody
Core (98)
5
2012-12-29
2007-08-23
Anonymous
No

Suppose you want to calculate the difference between 2 timestamp columns with the following query :

select lastmodifiedtime - createtime from mytable;

where mytable looks like:

create table mytable (
id integer not null,
createtime timestamp(6) not null,
lastmodifiedtime timestamp(6) not null
);

SQuirreL displays the result as :

Unknown(-104)

The column type name in the MetaData tab is INTERVALDS and the type code is -104.

SQL-Plus yields

+000000000 00:00:02:490000

which indicates a difference of approximately 2.49 seconds.

Discussion


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks