Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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 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    

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group