Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit4400976

Browse files
committed
Improve documentation of EXTRACT(WEEK).
The docs showed that early-January dates can be considered part of theprevious year for week-counting purposes, but failed to say explicitlythat late-December dates can also be considered part of the next year.Fix that, and add a cross-reference to the "isoyear" field. Per bug#7967 from Pawel Kobylak.
1 parentcce7486 commit4400976

File tree

1 file changed

+11
-8
lines changed

1 file changed

+11
-8
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 11 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -6919,16 +6919,19 @@ SELECT EXTRACT(SECOND FROM TIME '17:12:28.5');
69196919
<listitem>
69206920
<para>
69216921
The number of the week of the year that the day is in. By definition
6922-
(<acronym>ISO</acronym> 8601), the first week of a year
6923-
contains January 4 of that year. (The <acronym>ISO</acronym>-8601
6924-
week starts on Monday.) In other words, the first Thursday of
6925-
a year is in week 1 of that year.
6922+
(<acronym>ISO</acronym> 8601), weeks start on Mondays and the first
6923+
week of a year contains January 4 of that year. In other words, the
6924+
first Thursday of a year is in week 1 of that year.
69266925
</para>
69276926
<para>
6928-
Because of this, it is possible for early January dates to be part of the
6929-
52nd or 53rd week of the previous year. For example, <literal>2005-01-01</>
6930-
is part of the 53rd week of year 2004, and <literal>2006-01-01</> is part of
6931-
the 52nd week of year 2005.
6927+
In the ISO definition, it is possible for early-January dates to be
6928+
part of the 52nd or 53rd week of the previous year, and for
6929+
late-December dates to be part of the first week of the next year.
6930+
For example, <literal>2005-01-01</> is part of the 53rd week of year
6931+
2004, and <literal>2006-01-01</> is part of the 52nd week of year
6932+
2005, while <literal>2012-12-31</> is part of the first week of 2013.
6933+
It's recommended to use the <literal>isoyear</> field together with
6934+
<literal>week</> to get consistent results.
69326935
</para>
69336936

69346937
<screen>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp