CHAPTER 10
Working with Dates and Times
by Wayne Sheffield
SQL Server has several different date and time data types, which have varying levels of range and precision (and corresponding varying levels of storage requirement space). SQL Server also has numerous functions to retrieve, modify, and validate the data from these data types in their 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
Problem ...
Get SQL Server T-SQL Recipes, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
