postgres.git / summary / log / commit / refs

commit    f67a3d42688adf8045fe9bfaec699abbc6a33c83
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Tue Dec 26 20:31:50 2023 +0000
First released in: 17.0

    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


 doc/src/sgml/func.sgml | 6 ++++++
 1 file changed, 6 insertions(+)

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
@@ -8748,6 +8748,12 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}');
         <entry><literal>to_char(current_timestamp, 'FMDay,&nbsp;FMDD&nbsp;&nbsp;HH12:MI:SS')</literal></entry>
         <entry><literal>'Tuesday,&nbsp;6&nbsp;&nbsp;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>'&nbsp;&nbsp;-.10'</literal></entry>


[parent: bbf1f1340800]