Whitepaper : Making Time Using Temporal Data

Author: Joe Celko

SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what was already in most SQL products by that time. The problem is that each vendor made a trade-off internally.

In this whitepaper, learn about temporal data and how to improve your SQL code. The whitepaper describes how to make time using temporal data, the ISO temporal model, SQL temporal data types, tips for handling dates and times, date and time format standards, time in a database, time zones, interval data types, queries with date arithmetic, and much more.

Presenter: Joe Celko

Mr. Joe Celko serves as Member of Technical Advisory Board of Cogito, Inc. Mr. Celko joined the ANSI X3H2 Database Standards Committee in 1987 and helped write the ANSI/ISO SQL-89 and SQL-92 standards. He is one of the top SQL experts in the world, writing over 700 articles primarily on SQL and database topics in the computer trade and academic press. The author of six books on databases and SQL, Mr. Celko also contributes his time as a speaker and instructor at universities, trade conferences, and local user groups.

Register to read the full whitepaper.

Topics : Data Governance,Data Modeling,Database Development,SQL Query Performance,

Products : SQL Query Tuner,

Register for Free Whitepaper

Note: By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.