diff options
author | Bruce Momjian <bruce@momjian.us> | 2003-12-21 04:34:36 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2003-12-21 04:34:36 +0000 |
commit | 0ea4f9c859dc48ad228e63cc29a225a29939a26d (patch) | |
tree | d97633ce8c57259822d0c3ebe42981a117982645 /doc/src | |
parent | ced30eb8575d4e129f4c12a1317d3a615a1fa66a (diff) |
Back out:
> Attached is a patch that addressed all the discussed issues
> that did not break backward compatability, including the
> ability to output ISO-8601 compliant intervals by setting
> datestyle to iso8601basic.
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/datatype.sgml | 61 |
1 files changed, 1 insertions, 60 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 767f4aeff32..8d24f146547 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.138 2003/12/20 16:06:54 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/datatype.sgml,v 1.139 2003/12/21 04:34:35 momjian Exp $ --> <chapter id="datatype"> @@ -1785,55 +1785,6 @@ January 8 04:05:06 1999 PST <replaceable>p</replaceable> should be between 0 and 6, and defaults to the precision of the input literal. </para> - - - <para> - Alternatively, <type>interval</type> values can be written as - ISO 8601 time intervals, using the "Format with time-unit designators". - This format always starts with the character <literal>'P'</>, followed - by a string of values followed by single character time-unit designators. - A <literal>'T'</> separates the date and time parts of the interval. - </para> - - <para> - Format: PnYnMnDTnHnMnS - </para> - <para> - In this format, <literal>'n'</> gets replaced by a number, and - <literal>Y</> represents years, - <literal>M</> (in the date part) months, - <literal>D</> months, - <literal>H</> hours, - <literal>M</> (in the time part) minutes, - and <literal>S</> seconds. - </para> - - - <table id="interval-example-table"> - <title>Interval Example</title> - <tgroup cols="2"> - <thead> - <row> - <entry>Traditional</entry> - <entry>ISO-8601 time-interval</entry> - </row> - </thead> - <tbody> - <row> - <entry>1 month</entry> - <entry>P1M</entry> - </row> - <row> - <entry>1 hour 30 minutes</entry> - <entry>PT1H30M</entry> - </row> - <row> - <entry>2 years 10 months 15 days 10 hours 30 minutes 20 seconds</entry> - <entry>P2Y10M15DT10H30M20S</entry> - </row> - </tbody> - </tgroup> - </table> </sect3> <sect3> @@ -1990,11 +1941,6 @@ January 8 04:05:06 1999 PST <entry>regional style</entry> <entry>17.12.1997 07:37:16.00 PST</entry> </row> - <row> - <entry>ISO8601basic</entry> - <entry>ISO 8601 basic format</entry> - <entry>19971217T073716-08</entry> - </row> </tbody> </tgroup> </table> @@ -2052,11 +1998,6 @@ January 8 04:05:06 1999 PST </para> <para> - If the <varname>datestyle</> is set to iso8601basic, the interval - output is a ISO-8601 time interval with time-unit designator (like P1Y6M or PT23H59M59S). - </para> - - <para> The date/time styles can be selected by the user using the <command>SET datestyle</command> command, the <varname>datestyle</varname> parameter in the |