Abstract
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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Jason Brimhall, Jonathan Gennick, and Wayne Sheffield
About this chapter
Cite this chapter
Brimhall, J., Gennick, J., Sheffield, W. (2015). Chapter 10: Working with Dates and Times. In: SQL Server T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0061-2_10
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0061-2_10
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0062-9
Online ISBN: 978-1-4842-0061-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books