Thread: FX modifier

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/functions-formatting.html
Description:

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?

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