## SQLWays - Oracle Version Differences

Oracle versions are compatible in most ways. This chapter describes differences between Oracle 9i, 8i, 8.0.x and 7.3.

- TIMESTAMP data type

### TIMESTAMP data type

Requirements: Oracle 9i Release 1 (9.0.1) or later.

The TIMESTAMP data type is an extension of the DATE data type. For each TIMESTAMP value, Oracle stores the following information: year, month, day, hour, minute, second and fraction of second.

fractional_seconds_precision optionally specifies the number of digits in the fractional part of second and can be a number in the range 0 to 9. The default is 6.

For more information, see Oracle Data Types

[Main] [Table of Contents]
Copyright © 1999-2003 Ispirer Systems. All Rights Reserved.
SQLWays™ www.ispirer.com.