Commitf67a3d4

committed

doc: add ISO 8601 extended format example using to_char()

Reported-by: juha.mustonen@iki.fiDiscussion:https://postgr.es/m/20170217160154.6101.52806@wrigleys.postgresql.orgCo-authored-by: Erik WienholdBackpatch-through: master

1 parentbbf1f13 commitf67a3d4Copy full SHA for f67a3d4

File tree

-0

lines changed

-0

lines changed

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -8748,6 +8748,12 @@ SELECT regexp_match('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`8748`	`8748`	`<entry><literal>to_char(current_timestamp, 'FMDay, FMDD  HH12:MI:SS')</literal></entry>`
`8749`	`8749`	`<entry><literal>'Tuesday, 6  05:39:18'</literal></entry>`
`8750`	`8750`	`</row>`
	`8751`	`+ <row>`
	`8752`	`+ <entry><literal>to_char(current_timestamp AT TIME ZONE`
	`8753`	`+ 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"')</literal></entry>`
	`8754`	`+ <entry><literal>'2022-12-06T05:39:18Z'</literal>,`
	`8755`	`+ <acronym>ISO</acronym> 8601 extended format</entry>`
	`8756`	`+ </row>`
`8751`	`8757`	`<row>`
`8752`	`8758`	`<entry><literal>to_char(-0.1, '99.99')</literal></entry>`
`8753`	`8759`	`<entry><literal>'  -.10'</literal></entry>`

Comments

(0)