Chapter 12. Understanding Dates and Times
In this hour, you will learn about the nature of dates and times in SQL. Not only does this hour discuss the DATETIME data type in more detail, but you will also see how some implementations use dates, how to extract the date and time in a desired format, and some of the common rules.
The highlights of this hour include:
Understanding dates and time
How date and time are stored
Typical date and time formats
How to use date functions
How to use date conversions
By the Way
As you know by now, there are many different SQL implementations. This book shows the ANSI standard and the most common nonstandard functions, ...
Get Sams Teach Yourself SQL in 24 Hours, 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.
