tinterval and timespan
От | wr@tribe.ping.de |
---|---|
Тема | tinterval and timespan |
Дата | |
Msg-id | 19980531190721.14978@tribe.ping.de обсуждение исходный текст |
Список | 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@keys.pgp.net Fax: +49 234 540239 D-44807 Bochum with "get 0xED527449" in the subject
В списке pgsql-general по дате отправления: