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 :
The column type name in the MetaData tab is INTERVALDS and the type code is -104.
which indicates a difference of approximately 2.49 seconds.
Log in to post a comment.