Re: Problem with date formatting and FM

"Kistler, Winnie C." <kistlerwc(at)ornl(dot)gov> writes:
> I am noticing that whenever I put "FM" in front of the date (DD), it seems to affect the hour and minutes of the time as well.
> So for example:
> to_char(entry_date, 'Mon FMDD YYYY HH12:MIAM') converts '2014-04-01 15:07:00' to 'Apr 1 2014 3:7PM'
> In this example, I would expect the result to look like: 'Apr 1 2014 03:07PM'

I can't reproduce that.

regression=# select to_char('2014-04-01 15:07:00'::timestamp, 'Mon DD YYYY HH12:MIAM');
to_char
---------------------
Apr 01 2014 03:07PM
(1 row)

regression=# select to_char('2014-04-01 15:07:00'::timestamp, 'Mon FMDD YYYY HH12:MIAM');
to_char
--------------------
Apr 1 2014 03:07PM
(1 row)

> We are using PostgreSQL version 9.4.1.4.
> EnterpriseDB 9.4.1.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit

Hm. You should be asking EDB for support then, not the PG community.
But I wonder whether EDB has modified their version to be more
Oracle-like on this point.

regards, tom lane