O'Reilly logo

Sams Teach Yourself SQL in 24 Hours, Fifth Edition by Arie D. Jones, Ron D. Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required