Sams Teach Yourself SQL in 21 Days, Fourth Edition

Summary

Today, we have provided you with an understanding of DATETIME values based on the fact that ANSI has provided a standard. However, as with many elements of SQL, most implementations have deviated from the exact functions and syntax of standard SQL commands. The concepts, however, will always remain the same as far as the basic representation and manipulation of date and time information. During Day 12, “Controlling Transactions,” you saw how functions greatly varied depending upon each implementation. Today, you have seen some of the differences between Date and Time data types, functions, and operators. Keep in mind that not all examples discussed in this chapter will work with your particular implementation, but the concepts of dates ...