Re: Converting seconds past midnight to a time

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Converting seconds past midnight to a time
Date: 2005-12-18 07:29:45
Message-ID: 1134890985l.18569l.11l@mofo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches


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(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Velevitch 2005-12-18 08:50:34 update count
Previous Message Karl O. Pinc 2005-12-18 04:35:26 Re: DBlink documentation

Browse pgsql-patches by date

  From Date Subject
Next Message Volkan YAZICI 2005-12-18 10:13:17 tuple count and v3 functions in psql for COPY
Previous Message Tom Lane 2005-12-18 04:26:25 Re: Converting seconds past midnight to a time