pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedFX modifier
2+ messages / 2 participants
[nested] [flat]
* FX modifier
@ 2018-06-14 20:16 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2018-06-14 20:16 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: bob.rumsby@yahoo.com
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: FX modifier
@ 2018-06-19 18:11 Euler Taveira <euler@timbira.com.br>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Euler Taveira @ 2018-06-19 18:11 UTC (permalink / raw)
To: bob.rumsby@yahoo.com; pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-06-19 18:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-06-14 20:16 FX modifier PG Doc comments form <noreply@postgresql.org>
2018-06-19 18:11 ` Euler Taveira <euler@timbira.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox