Hour 12. Understanding Dates and Times
What You’ll Learn in This Hour:
• 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
In this hour, you learn about the nature of dates and time in SQL. Not only does this hour discuss the DATETIME data type in more detail, but you also see how some implementations use dates, how to extract the date and time in a desired format, and some of the common rules.
By the Way: Variations in the SQL Syntax
As you know by now, there are many different SQL implementations. This book shows the American National Standards Institute (ANSI) standard and the most common nonstandard functions, commands, and operators. MySQL ...
Get Sams Teach Yourself SQL in 24 Hours, Fifth 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.
