"Kistler, Winnie C." <kistlerwc@ornl.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
aswell.
> 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