The function does not define what a "Gregorian day" is, nor why it would be different in the 1900 versus 1904 date bases for a date in 1982. Is this just returning the day of the month Why would this function return two values for that in 1982

Define fully what this function returns.

3.17.7.78 te

DAY 2605(2612)

Proposed Disposition of DIS 29500 Comment CO-0181 (Modified: 2007-11-30) We agree ­ “Gregorian day” is ambiguous in the definition for the DAY function. Similar phrasing is used in MONTH and YEAR, so we propose also rephrasing them. With the regard to the concern over 1900/1904 date base conversion, we feel that there are already several examples in the specification that highlight the behaviour. To clarify, when the date is passed into the DAY function as text, it will be coerced internally into a numeric date value using the current date base. The DAY function will then use that same date base to establish the day of the month, and so the results of this function will be equal for either date base. If the date is passed into the DAY function as a number, there’s no way to establish the date base used and therefore “1″ will represent either 1 st Jan 1900 or 1 st Jan 1904, depending on which is the current date base. The DAY function, therefore, will return different results, as the positioning of leap years will not be the same. The following changes will be made: Part 4, §3.17.7.78, page 2,606, line 1 Description: Computes the numeric Gregorian day of the month in the Gregorian calendar [ISO 8601 §3.2.1] for the date and/or time having the given date-value, taking into account the current date base value. Part 4, §3.17.7.78, page 2,606, line 5 Return Type and Value: number ­ The Gregorian day of the month in the Gregorian calendar [ISO 8601 §3.2.1] for the date and/or time having the given date-value. The returned value shall be in the range 1­ 31. However, if date-value is out of range for the current date base value, #NUM! is returned. Part 4, §3.17.7.218, page 2,718, line 1 Description: Computes the numeric Gregorian month in the Gregorian calendar [ISO 8601 §3.2.1] for the date and/or time having the given date-value, taking into account the current date base value. That date and/or time shall be expressed either as a serial value, in which case, its fractional part is ignored, or as a string-constant having any valid date and/or time format, in which case, any time information shall be ignored. Part 4, §3.17.7.218, page 2,718, line 7 Return Type and Value: number ­ The Gregorian month in the Gregorian calendar [ISO 8601 §3.2.1] for the date and/or time having the given date-value, in the range 1­12 1900­9999 . Part 4, §3.17.7.347, page 2,825, line 11 Description: Computes the numeric Gregorian year in the Gregorian calendar [ISO 8601 §3.2.1] for the date and/or time having the given date-value, taking into account the current date base value. That date and/or time shall be expressed either as a serial value, in which case, its fractional part is ignored, or as a string-constant having any valid date and/or time format, in which case, any time information shall be ignored. Part 4, §3.17.7.347, page 2,825, line 17 Return Type and Value: number ­ The Gregorian year in the Gregorian calendar [ISO 8601 §3.2.1] for the date and/or time having the given date-value. For the 1900 date base system, the returned value shall be in the range 1900­9999. For the 1904 date base system, the returned value shall be in the range 1904­9999. Similar Comments: CL-0189 , DK-0035 , FR-0514 , GB-0394 , US-0279

Tag and Go

No Comments

Sorry, the comment form is closed at this time.

  • Argentina (1)
  • Australia (30)
  • Austria (1)
  • Belgium (1)
  • Brazil (64)
  • Bulgaria (3)
  • Canada (79)
  • Chile (217)
  • China (1)
  • Colombia (237)
  • Czech Republic (75)
  • Denmark (168)
  • Ecma (76)
  • Ecuador (1)
  • Finland (15)
  • France (592)
  • Germany (162)
  • Ghana (12)
  • Greece (113)
  • India (82)
  • Iran (58)
  • Ireland (12)
  • Israel (33)
  • Italy (2)
  • Japan (82)
  • Jordan (1)
  • Kenya (81)
  • Malaysia (23)
  • Malta (5)
  • Mexico (7)
  • New Zealand (54)
  • Norway (12)
  • Peru (10)
  • Philippines (7)
  • Poland (4)
  • Portugal (118)
  • Singapore (2)
  • South Africa (17)
  • South Korea (25)
  • Spain (1)
  • Switzerland (19)
  • Thailand (1)
  • Tunisia (3)
  • Turkey (1)
  • UK (635)
  • Uruguay (18)
  • USA (288)
  • Venezuela (73)