Re: FX modifier

2018-06-14 17:16 GMT-03:00 PG Doc comments form <noreply@postgresql.org>:
> The FX modifier is defined only as "fixed format global option"--what does
> this mean?
> The usage notes do not mention FX for TO_CHAR. Does it work with TO_CHAR?
>
This is not a bug. The documentation is clear.

"to_timestamp and to_date skip multiple blank spaces in the input
string unless the FX option is used. For example, to_timestamp('2000
 JUN', 'YYYY MON') works, but to_timestamp('2000    JUN', 'FXYYYY
MON') returns an error because to_timestamp expects one space only. FX
must be specified as the first item in the template."

FX only applies to to_timestamp and to_date.


-- 
   Euler Taveira                                   Timbira -
http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento