diff options
| author | Bruce Momjian <bruce@momjian.us> | 2023-12-26 15:31:50 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2023-12-26 15:31:50 -0500 |
| commit | f67a3d42688adf8045fe9bfaec699abbc6a33c83 (patch) | |
| tree | 287946f0fd149b5c04b4fa99bef7c0fb8977a566 | |
| parent | bbf1f1340800da38625ea7034dca3c14c6431f64 (diff) | |
| download | postgresql-f67a3d42688adf8045fe9bfaec699abbc6a33c83.tar.gz postgresql-f67a3d42688adf8045fe9bfaec699abbc6a33c83.zip | |
doc: add ISO 8601 extended format example using to_char()
Reported-by: juha.mustonen@iki.fi
Discussion: https://postgr.es/m/20170217160154.6101.52806@wrigleys.postgresql.org
Co-authored-by: Erik Wienhold
Backpatch-through: master
| -rw-r--r-- | doc/src/sgml/func.sgml | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 20da3ed0334..cec21e42c05 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -8749,6 +8749,12 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}'); <entry><literal>'Tuesday, 6 05:39:18'</literal></entry> </row> <row> + <entry><literal>to_char(current_timestamp AT TIME ZONE + 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"')</literal></entry> + <entry><literal>'2022-12-06T05:39:18Z'</literal>, + <acronym>ISO</acronym> 8601 extended format</entry> + </row> + <row> <entry><literal>to_char(-0.1, '99.99')</literal></entry> <entry><literal>' -.10'</literal></entry> </row> |