From 0ea4f9c859dc48ad228e63cc29a225a29939a26d Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 21 Dec 2003 04:34:36 +0000 Subject: 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. --- doc/src/sgml/datatype.sgml | 61 +--------------------------------------------- 1 file changed, 1 insertion(+), 60 deletions(-) (limited to 'doc/src') 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 @@ @@ -1785,55 +1785,6 @@ January 8 04:05:06 1999 PST p should be between 0 and 6, and defaults to the precision of the input literal. - - - - Alternatively, interval values can be written as - ISO 8601 time intervals, using the "Format with time-unit designators". - This format always starts with the character 'P', followed - by a string of values followed by single character time-unit designators. - A 'T' separates the date and time parts of the interval. - - - - Format: PnYnMnDTnHnMnS - - - In this format, 'n' gets replaced by a number, and - Y represents years, - M (in the date part) months, - D months, - H hours, - M (in the time part) minutes, - and S seconds. - - - - - Interval Example - - - - Traditional - ISO-8601 time-interval - - - - - 1 month - P1M - - - 1 hour 30 minutes - PT1H30M - - - 2 years 10 months 15 days 10 hours 30 minutes 20 seconds - P2Y10M15DT10H30M20S - - - -
@@ -1990,11 +1941,6 @@ January 8 04:05:06 1999 PST regional style 17.12.1997 07:37:16.00 PST - - ISO8601basic - ISO 8601 basic format - 19971217T073716-08 - @@ -2051,11 +1997,6 @@ January 8 04:05:06 1999 PST - - If the datestyle is set to iso8601basic, the interval - output is a ISO-8601 time interval with time-unit designator (like P1Y6M or PT23H59M59S). - - The date/time styles can be selected by the user using the SET datestyle command, the -- cgit v1.2.3