Re: Converting seconds past midnight to a time - Mailing list pgsql-general

From Karl O. Pinc
Subject Re: Converting seconds past midnight to a time
Date
Msg-id 1134890985l.18569l.11l@mofo
Whole thread Raw
In response to Re: Converting seconds past midnight to a time  (Michael Glaesemann <grzm@myrealbox.com>)
Responses Re: Converting seconds past midnight to a time
List pgsql-general
On 12/17/2005 10:21:39 PM, Michael Glaesemann wrote:
>
> On Dec 18, 2005, at 13:25 , Karl O. Pinc wrote:
>> On a related note is there some reason why
>> interval + int
>> does not result in the interval plus int number
>> of seconds?
>
> Why should the int necessarily represent seconds and not some other
> amount of time? It's just a unit-less value.

Good question.  I guess it's because I couldn't corece
an int into an interval number of seconds. ;-)  But if it was to be
anything it should be seconds or milliseconds as those
are the only ones that make the math easy, in the sense of
working with whole numbers.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Converting seconds past midnight to a time
Next
From: Chris Velevitch
Date:
Subject: update count