summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2003-12-21 04:34:36 +0000
committerBruce Momjian <bruce@momjian.us>2003-12-21 04:34:36 +0000
commit0ea4f9c859dc48ad228e63cc29a225a29939a26d (patch)
treed97633ce8c57259822d0c3ebe42981a117982645 /doc/src
parentced30eb8575d4e129f4c12a1317d3a615a1fa66a (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.sgml61
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