| #### Developing Time-Oriented Database Applications in SQL Richard T. Snodgrass |

# MANIPULATING DATA TYPES

## Contents :

This document outlines temporal data type support for the Microsoft Access DBMS, as described in Chapters 2 & 3. It follows the general outline of the TDB book and is arranged in the following manner.

> Instants and Intervals

> > Operations
> > Examples

> Periods

> > Operations
> > Examples

#

# Generic Implementation Details

## Schema for the Examples

> Employee Table (Test Data)

Name STRING | Birthdate DATE | Project_time TIME | Checkin_time TIMESTAMP | Checkout_time TIMESTAMP

#

# Instants and Intervals

## Operations

> Microsoft Access 2000
> IBM DB2 Universal Server
> Informix Universal Server
> Ingres
> Oracle8 Server
> Microsoft SQL Server
> Sybase SQL Server
> UniSQL

## Examples

> Microsoft Access 2000
> Informix Universal Server
> Ingres
> Oracle8 Server
> Sybase SQL Server
> UniSQL

#

# Periods

## Operations

> Microsoft Access 2000
> IBM DB2 Universal Server
> Informix Universal Server
> Ingres
> Oracle8 Server
> Microsoft SQL Server
> Sybase SQL Server
> UniSQL

## Examples

> Microsoft Access 2000
> Informix Universal Server
> Ingres
> Oracle8 Server
> Sybase SQL Server
> UniSQL

#### HTML Credits

Jose Alvin G. Gendrano, Department of Computer Science, University of Arizona (jag@cs.arizona.edu)
Rachana R. Shah, Department of Computer Science, University of Arizona (rachana@cs.arizona.edu)
Jian Yang, Department of Computer Science, University of Arizona (yangjian@cs.arizona.edu)
April 28, 1999(Last Update)