Horton

Re: missing "day(s)" in interval (was: Convert from Seconds-Since-Epoch to Timestamp)

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: ldm@apartia.ch
Cc: Thomas Lockhart <lockhart@alumni.caltech.edu>, pgsql-sql@postgresql.org
Date: 2000-09-23T16:46:18Z
Lists: pgsql-sql 
Louis-David Mitterrand <cunctator@apartia.ch> writes:
> By the way, is it normal that the "day" word doesn't appear in the interval?

> auction=# select interval(now()::abstime::int4);
>           interval          
> ----------------------------
>  30 years 9 mons 3 15:42:09
> (1 row)

Looks like a bug to me ... Thomas, do you agree?

Curiously, it appears that the interval input converter will accept this
with or without the 'days' keyword included.

			regards, tom lane