O'Reilly logo

Sams Teach Yourself SQL by Arie D. Jones, Ron 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

Chapter 12. Understanding Dates and Times

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

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