User Documentation
Ispirer Toolkit Overview
Pricing
HP Neoview Data Types - INTERVAL DAY/TIME
Versions: HP Neoview 2.4, 2.3 and 2.2
| HP Neoview - INTERVAL DAY/TIME | |
|---|---|
| Syntax | INTERVAL [largest_qualifier[(p)] TO smallest_qualifier] |
| Data | Period of time in days and/or time. The largest_qualifier can be DAY, HOUR and MINUTE, smallest_qualifier can be DAY, HOUR, MINUTE and SECOND(fractional_precision) provided that smallest_qualifier does not specify a larger time unit than largest_qualifier p is the precision for largest_qualifier, optional |
| Range | 0 ⇐ p ⇐ 18, 0 ⇐ fractional_precision ⇐ 6 |
| Defaults | p is 2, fractional_precision is 6 (microseconds) |
| Standards | HP Neoview Extension |
HP Neoview INTERVAL DAY/TIME - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | INTERVAL DAY TO SECOND |
| PostgreSQL | INTERVAL |
| Informix | INTERVAL day-time |
Related Data Types in HP Neoview
| Data Types | |||
|---|---|---|---|
| Datetime | DATE | TIME(p) | TIMESTAMP(p) |
| Intervals | INTERVAL year-month | ||
All Data Types