Some units of measure allowed as arguments to the CONVERT function are under-defined. Traditional liquid measures such as “cup” and “tablespoon” vary from country to country. The DIS does not specify which version is assumed.

The specification should define the units of measurement for arguments to the CONVERT function.

Table “Liquid Measure”, p2575 Part 4, Section 3.17.7.48

te

Proposed Disposition of DIS 29500 Comment IE-0006 (Modified: 2008-01-13) We agree that several of the measures inside the CONVERT function are ambiguously defined. We will make the following changes: Part 4, §3.17.7.48, page 2,572, line 17 Description: Converts a number from one measurement system to another. Part 4, §3.17.7.48, page 2,575, the first table Liquid Measure Unit String Meaning Cup Traditional U.S. Cup (1/2 U.S. pint) Gal U.S. Gallon l or lt Liter Oz U.S. Fluid ounce Pt or us_pt U.S. pint Qt U.S. Quart Tbs Traditional U.S. Tablespoon (1/2 U.S. fluid ounce) Tsp Traditional U.S. Teaspoon (1/6 U.S. fluid ounce) uk_pt U.K. pint Part 1, §3, “Normative References”, add the following: “NIST Guide to SI Units”, http://physics.nist.gov/Pubs/SP811/appenB9.html Similar Comments: AU-0028 , CL-0180 , CO-0172 , ECMA-0027 , FR-0503 , GB-0384 , MT-0003 , PH-0004 , US-0183 , UY-0012

Tag and Go

1 Comment

  1. hAl September 25, 2007 @ 3:56 pm

    Dupe of Ecma 27

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)