We assume you are converting between gram [water] and teaspoon [metric]. The SI derived unit for volume is the cubic meter. 1 cubic meter is equal to 1000000 grams, or 200000 teaspoons. Note that rounding errors may occur, so always check the results. Use this page to learn how to convert between grams and teaspoons.
Outside the UK,the calculation of defined. daily doses (DDDs) is widely used.The DDD. is the assumed average maintenance dose per. day for a drug when used for its main indica-. tion in adults with normal organ function.
The DATEADD function simply allows you to add or subtract the specified number of units of time to a specified date/time value. The format of the DATEADD function is as follows: DATEADD(<Unit of time>, <Units>, <Date>) -- to add 5 days to September 1, 2011 the function would be. DATEADD(DAY, 5, '9/1/2011') -- to subtract 5 months from September 1, 2011 the function would be. DATEADD(MONTH, -5, '9/1/2011') A thing to note is that the date format can be any date format that SQL Server recognizes such as: 9/1/2011. 9/1/2011 12:30.