NotificationsYou must be signed in to change notification settings
Fork5
Star27

Commit10257fc

committed

Fix documentation of to_char/to_timestamp TZ, tz, OF formatting patterns.

These are only supported in to_char, not in the other direction, but thedocumentation failed to mention that. Also, describe TZ/tz as printing thetime zone "abbreviation", not "name", because what they print is elsewherereferred to that way. Per bug #14558.

1 parent090f21b commit10257fcCopy full SHA for 10257fc

File tree

1 file changed

-3

lines changed

doc/src/sgml
- func.sgml

1 file changed

-3

lines changed

`‎doc/src/sgml/func.sgml‎`

Lines changed: 6 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -6062,15 +6062,18 @@ SELECT regexp_match('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`6062`	`6062`	`</row>`
`6063`	`6063`	`<row>`
`6064`	`6064`	`<entry><literal>TZ</literal></entry>`
`6065`		`- <entry>upper case time-zone name</entry>`
	`6065`	`+ <entry>upper case time-zone abbreviation`
	`6066`	`+ (only supported in <function>to_char</>)</entry>`
`6066`	`6067`	`</row>`
`6067`	`6068`	`<row>`
`6068`	`6069`	`<entry><literal>tz</literal></entry>`
`6069`		`- <entry>lower case time-zone name</entry>`
	`6070`	`+ <entry>lower case time-zone abbreviation`
	`6071`	`+ (only supported in <function>to_char</>)</entry>`
`6070`	`6072`	`</row>`
`6071`	`6073`	`<row>`
`6072`	`6074`	`<entry><literal>OF</literal></entry>`
`6073`		`- <entry>time-zone offset</entry>`
	`6075`	`+ <entry>time-zone offset from UTC`
	`6076`	`+ (only supported in <function>to_char</>)</entry>`
`6074`	`6077`	`</row>`
`6075`	`6078`	`</tbody>`
`6076`	`6079`	`</tgroup>`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit10257fc

File tree

1 file changed

1 file changed

`‎doc/src/sgml/func.sgml‎`

0 commit comments