From b27cef29324c456bb77ef617914e062877779de8 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Fri, 14 Apr 2000 15:08:56 +0000 Subject: [PATCH] Mention support for date_part('week',timestamp). Fix spelling of "millennium". Thanks to Mika Nystrom . --- doc/src/sgml/datatype.sgml | 4 ++-- doc/src/sgml/func.sgml | 21 ++++++++++++++------- 2 files changed, 16 insertions(+), 9 deletions(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 9b34323303..a80674bf62 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ @@ -1022,7 +1022,7 @@ January 8 04:05:06 1999 PST Unit is second, minute, hour, day, week, month, year, - decade, century, millenium, + decade, century, millennium, or abbreviations or plurals of these units; Direction can be ago or empty. diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 67b8adaafb..8110c6325c 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -551,13 +551,19 @@ For the date_part and date_trunc functions, arguments can be - `year', `month', `day', `hour', `minute', and `second', + `year', `month', + `day', `hour', + `minute', and `second', as well as the more specialized quantities - `decade', `century', `millenium', `millisecond', and `microsecond'. - date_part allows `dow' - to return day of week and `epoch' to return seconds since 1970 - (for timestamp) - or 'epoch' to return total elapsed seconds (for interval). + `decade', `century', + `millennium', `millisecond', + and `microsecond'. + date_part allows `dow' + to return day of week, 'week' to return the + ISO-defined week of year, and `epoch' to return + seconds since 1970 (for timestamp) + or 'epoch' to return total elapsed seconds + (for interval). @@ -814,7 +820,8 @@ All templates allow the use of prefix and suffix modifiers. Modifiers are - always valid for use in templates. The prefix 'FX' is a global modifier only. + always valid for use in templates. The prefix + 'FX' is a global modifier only. -- 2.40.0