From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Result of timestamp - timestamp |
Date: | 2017-02-06 07:35:58 |
Message-ID: | o7990o$4fd$1@blaine.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Adrian Klaver schrieb am 05.02.2017 um 22:40:
>> I just stumbled about a report that has been running for a long time now
>> and that relied on the fact that the interval "timestamp - timestamp"
>> always returns an interval with days, hours, minutes. But never a
>> "justified" interval with years, months, days and so on.
>
> According to the docs:
>
> https://www.postgresql.org/docs/9.6/static/functions-datetime.html
>
> "Subtraction of date or timestamp values with the "-" operator returns the number of days (24-hours) and hours/minutes/seconds between the values, making the same adjustments."
>
> It should always return days and hours.
Ah, great. For some reason I didn't find that.
>> The query usees "extract(day from timestamp - timestamp)" which is
>> working fine, but would apparently fail if a justified interval was
>> returned
>
> Did that happen?
No it didn't. I just was curious if I relied on something that might change.
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Rui Pacheco | 2017-02-06 17:21:56 | Logging broken messages |
Previous Message | Adrian Klaver | 2017-02-05 21:40:31 | Re: Result of timestamp - timestamp |