Hour 12. Understanding Dates and Times In this hour, you will 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 will also see how some implementations use dates, some of the common rules, and how to extract the date and time in a desired format. 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 | | As you know by now, there are many different SQL implementations. This book shows the ANSI standard and the most common nonstandard functions, commands, and operators. Oracle is used for the examples. Even in Oracle, the date can be stored in different formats. You must check your particular implementation for the date storage. No matter how it is stored, your implementation should have functions that convert date formats. | |