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

Commitb8f4599

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 parent3263896 commitb8f4599

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
@@ -6935,16 +6935,19 @@ SELECT EXTRACT(SECOND FROM TIME '17:12:28.5');
69356935
<listitem>
69366936
<para>
69376937
The number of the week of the year that the day is in. By definition
6938-
(<acronym>ISO</acronym> 8601), the first week of a year
6939-
contains January 4 of that year. (The <acronym>ISO</acronym>-8601
6940-
week starts on Monday.) In other words, the first Thursday of
6941-
a year is in week 1 of that year.
6938+
(<acronym>ISO</acronym> 8601), weeks start on Mondays and the first
6939+
week of a year contains January 4 of that year. In other words, the
6940+
first Thursday of a year is in week 1 of that year.
69426941
</para>
69436942
<para>
6944-
Because of this, it is possible for early January dates to be part of the
6945-
52nd or 53rd week of the previous year. For example, <literal>2005-01-01</>
6946-
is part of the 53rd week of year 2004, and <literal>2006-01-01</> is part of
6947-
the 52nd week of year 2005.
6943+
In the ISO definition, it is possible for early-January dates to be
6944+
part of the 52nd or 53rd week of the previous year, and for
6945+
late-December dates to be part of the first week of the next year.
6946+
For example, <literal>2005-01-01</> is part of the 53rd week of year
6947+
2004, and <literal>2006-01-01</> is part of the 52nd week of year
6948+
2005, while <literal>2012-12-31</> is part of the first week of 2013.
6949+
It's recommended to use the <literal>isoyear</> field together with
6950+
<literal>week</> to get consistent results.
69486951
</para>
69496952

69506953
<screen>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp