Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Database Migration Request SQLWays

Ingres Data Types - TIME

Versions: Ingres 9.x and 10.0

Ingres - TIME
Syntax TIME[(p)] [WITH|WITH LOCAL|WITHOUT TIME ZONE]
Data Time data (hours, minutes, seconds)
Parameters p indicates the number of digits of precision in the fractions of seconds, as an integer value from 0 to 9
Range 00:00:00 to 24:00:00
Default p is 0
Standards ANSI SQL

Ingres 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 to 23:59:59:9999999 (100 nanoseconds accuracy)
MySQL TIME, -838:59:59 to 838:59:59 (seconds accuracy)
PostgreSQL TIME(p), 00:00:00:000000 and 23:59:59:999999 (microseconds accuracy)
Sybase ASE TIME, 00:00:00:000 to 23:59:59:999 (milliseconds accuracy)
Informix DATETIME HOUR TO FRACTION(5), 00:00:00:00000 to 23:59:59:99999 (10 microseconds accuracy)
HP Neoview TIME(p), 00:00:00:000000 and 23:59:59:999999 (microseconds accuracy)

Related Data Types in Ingres

Data Types
Datetime DATE TIMESTAMP(p) ANSIDATE INGRESDATE
Intervals INTERVAL

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Database Migration Request SQLWays

sqlways/ingres/data-types/time.txt · Last modified: May 07, 2018, 03:15:28 PM (external edit)
 
© 1999-2022, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement