Ispirer Home Page
Ispirer SQLWays Product Page - Migration to Neoview
Request SQLWays
HP Neoview Data Types - INTERVAL YEAR/MONTH
Versions: HP Neoview 2.4, 2.3 and 2.2
| HP Neoview - INTERVAL | |
|---|---|
| Syntax | INTERVAL [largest_qualifier[(p)] TO smallest_qualifier] |
| Data | Period of time in years and/or months. The largest_qualifier and smallest_qualifier can be YEAR and MONTH 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 |
| Defaults | p is 2 |
| Standards | HP Neoview Extension |
HP Neoview INTERVAL YEAR/MONTH - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | INTERVAL YEAR TO MONTH |
| PostgreSQL | INTERVAL |
| Informix | INTERVAL year-month |
Related Data Types in HP Neoview
| Data Types | |||
|---|---|---|---|
| Datetime | DATE | TIME(p) | TIMESTAMP(p) |
| Intervals | INTERVAL day-time | ||
All Data Types
| Oracle | SQL Server | IBM DB2 | MySQL | PostgreSQL | Sybase ASE | Sybase ASA | Informix DS | Teradata | HP Neoview | Interbase/Firebird |
Ispirer Home Page
Ispirer SQLWays Product Page - Migration to Neoview
Request SQLWays