BUG #15698: to_char doesn't return expected value with negative INTERVAL

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

Responses

Browse pgsql-bugs by date

  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