HP Neoview Data Types - TIME

Versions: HP Neoview 2.4, 2.3 and 2.2

HP Neoview - TIME
Syntax	TIME[(p)]
Data	Time data (hours, minutes, seconds and fraction of seconds)
Parameters	p is the number of digits in the fractional part of second, 0 ⇐ p ⇐ 6 (microseconds)
Default	p is 0
Range	00:00:00:000000 and 23:59:59:999999
Storage Size	7 bytes (3 bytes without fraction)
Standards	ANSI SQL

HP Neoview TIME - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	TIMESTAMP(p), 00:00:00:000000000 and 23:59:59:999999999 (nanoseconds accuracy). Contains day part (year, month and day)
SQL Server	TIME(p), 00:00:00.0000000 and 23:59:59.9999999 (100 nanoseconds accuracy)
MySQL	TIME, -838:59:59 to 838:59:59 (seconds accuracy)
Postgre SQL	TIME(p), 00:00:00:000000 and 23:59:59:999999 (microseconds accuracy)
Sybase ASE	TIME, 00:00:00:000 and 23:59:59:999 (milliseconds accuracy)
Informix	DATETIME HOUR TO FRACTION(5), 00:00:00:00000 to 23:59:59:99999 (10 microseconds accuracy)
Ingres	TIME(p), 00:00:00 and 24:00:00

Related Data Types in HP Neoview

Data Types
Datetime	DATE	TIMESTAMP(p)
Intervals	INTERVAL year-month	INTERVAL day-time

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres