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