MySQL Forums
Forum List  »  Docs

Re: Quarter()
Posted by: Grant Wray
Date: November 30, 2016 01:05PM

Business practices vary both within and across countries. For example, some utilise a 13 week quarter, such as in the 4-4-5 system.

Read the section on WEEK(); there are various modes available which account for particular practises such as the 52-53 week scheme. Why are modes available for WEEK()? Is there no "common sense" definition of how week 1 of the year is defined?

Although there are international financial reporting standards, no reference is made in the documentation that the operation of the QUARTER function has been aligned to any particular standard. There's nothing wrong with documenting the exact operation of a function.

MySQL documentation does include information that the date/time system operates within the proleptic Gregorian calendar. What's the point of doing that? Surely that would be "common sense". I see nothing wrong in providing clarification, stating the boundaries and methods of a function's operation.

Options: ReplyQuote


Subject
Views
Written By
Posted
2190
November 29, 2016 04:58AM
1222
November 30, 2016 01:10AM
1234
November 30, 2016 04:56AM
1241
November 30, 2016 12:32PM
Re: Quarter()
1146
November 30, 2016 01:05PM
1184
November 30, 2016 02:06PM
1469
November 30, 2016 08:57PM
1326
November 30, 2016 09:18PM
1238
November 30, 2016 10:51PM
1214
November 30, 2016 11:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.