Introduction.
In this article I want to show how to manipulate date data type in Microsoft SQL Server and Oracle database. Most applications require to store and manipulate dates and times, and date manipulation is sometimes complicated not _disibledevent="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt">from dual;
Listing 22.
Conclusion.
In this article, I covered the main concepts related to date and time values. I illustrated the principles using several examples in the most important database systems today, Microsoft SQL Server and Oracle database.
 |
最新评论