Re: Problem with date formatting and FM

Tom,

Thanks for your reply. It is odd that it is behaving differently on our
system. I tried your example instead of using the "entry_date" column
just to be absolutely sure, and I get the same error. I also tried
toggling the "FM" but it doesn't seem to work like it does on Oracle. Will
check with EDB to see what they say.

Thank you,
Winnie Kistler

On 3/31/15 8:19 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>"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