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