Chapter 4 QUERYING AND MODIFYING DATA 219 TABLE
Chapter 4 QUERYING AND MODIFYING DATA 219 TABLE 4.7 POSSIBLE VALUES FOR DATE_PART date_part name Abbreviations Year yy, yyyy Quarter qq, q Month mm, m Dayofyear dy, y Day dd, d Week wk, ww Hour hh Minute mi, n Second ss, s Millisecond ms The DATEDIFF function is used in a similar manner. This function, however, calculates the amount of time in dateparts between the second and first of two dates you specify. DATEDIFF Included in the various date manipulation functions is DATEDIFF. As the name suggests, DATEDIFF is a function that returns the difference between two date parts specified. The syntax for DATEDIFF is DATEDIFF (date_part, start_date, end_date) Where: date_part is the unit of time measure you want to find the difference between. The values this can take are shown earlier in Table 4.7. start_date is the beginning date for the calculation. end_date is the date being subtracted from start_date.
For reliable and cheap web hosting services please check cheap web hosting website.