diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index e468ee62ff4..d36e4979b67 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -18017,16 +18017,15 @@ ERROR: jsonpath member accessor can only be applied to an object </para> <para> String value converted from a JSON boolean, number, string, or - datetime (the output format for datetimes is determined by - the <xref linkend="guc-datestyle"/> parameter) + datetime </para> <para> <literal>jsonb_path_query_array('[1.23, "xyz", false]', '$[*].string()')</literal> <returnvalue>["1.23", "xyz", "false"]</returnvalue> </para> <para> - <literal>jsonb_path_query('"2023-08-15"', '$.datetime().string()')</literal> - <returnvalue>"2023-08-15"</returnvalue> + <literal>jsonb_path_query('"2023-08-15 12:34:56"', '$.timestamp().string()')</literal> + <returnvalue>"2023-08-15T12:34:56"</returnvalue> </para></entry> </row> |