tinterval and timespan

From: wr(at)tribe(dot)ping(dot)de
To: pgsql-general(at)postgreSQL(dot)org
Subject: tinterval and timespan
Date: 1998-05-31 17:07:21
Message-ID: 19980531190721.14978@tribe.ping.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am still having problems with the timespan and tinterval types.

tinterval is defined as (abstime, abstime) but if set a value like
('2/2/1998, 2/2/1999') the result returned will be

["Thu Jan 01 01:04:06 1970 MET" "Thu Apr 25 07:54:08 1974 MET"]

timespan seems also worthless for me. I can define a timespan of years,
hours etc. but I am not able to use it as a time range starting from a
certain time. E. g. i would like to have a time range of 3 years starting
in 1998 and ending in year 2000. If i enter a value of '1998 years @ 2000
years' the resulting value will be '@ 3998'.

Could anyone give me a hint how to use these data types succesfully? Are
there any examples around?

Werner
--
Werner Reisberger public-key available: voice: +49 234 540294
Schoellmannstr. 20 pgp-public-keys(at)keys(dot)pgp(dot)net Fax: +49 234 540239
D-44807 Bochum with "get 0xED527449" in the subject

Browse pgsql-general by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-05-31 18:20:00 Re: [INTERFACES] no shared libs
Previous Message Marin D 1998-05-31 16:45:02 v6.3.2 - first imperssions