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
521
November 29, 2016 04:58AM
295
November 30, 2016 01:10AM
293
November 30, 2016 04:56AM
297
November 30, 2016 12:32PM
Re: Quarter()
269
November 30, 2016 01:05PM
292
November 30, 2016 02:06PM
407
November 30, 2016 08:57PM
335
November 30, 2016 09:18PM
316
November 30, 2016 10:51PM
282
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.