Working with Dates and Times
SQL Server has several different date and time data types, with varying levels of range and precision (and a corresponding varying level of storage requirement space). SQL Server also has numerous functions to retrieve, modify, and validate the data from these data types in various formats. This chapter focuses on these functions. Table 10-1 shows the various date/time data types.
Table 10-1. SQL Server Date/Time Data Types
10-1. Returning the Current Date and Time
You need ...