From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | s(dot)celles(at)gmail(dot)com |
Subject: | BUG #15698: to_char doesn't return expected value with negative INTERVAL |
Date: | 2019-03-16 20:11:19 |
Message-ID: | 15698-73406d98ae47f2af@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15698
Logged by: Sébastien Celles
Email address: s(dot)celles(at)gmail(dot)com
PostgreSQL version: 10.5
Operating system: Windows 10
Description:
Hello,
This is my first bug report here (despite I'm using PostgreSQL since many
years !)
I don't know if it's a bug... but the following query
SELECT to_char(-(3 * 60 * 60 * 1000 + 7*60 * 1000 + 12345) * INTERVAL '1
millisecond', 'HH24:MI:SS.MS') as interv;
doesn't return the result I was expecting.
It returns:
'-03:-07:-12.-345'
I was expecting
'-03:07:12.345'
If it's not a bug (but a feature ;-) )... is there a way to return result as
I was expecting.
Kind regards
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2019-03-17 10:00:35 | BUG #15699: PostgreSQL query rewrite don's use the same rewrite rule for the JOIN QUERY. |
Previous Message | Tom Lane | 2019-03-16 14:46:42 | Re: BUG #15696: year field of interval type is not rounded to nearest integer |