SQL Server Data Types - TIME

Versions: SQL Server 2008

SQL Server - 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 ⇐ 7
Default	p is 7 (100 nanoseconds)
Range	00:00:00:0000000 and 23:59:59:9999999
Version Differences	TIME is available since SQL Server 2008
Storage Size	5 bytes
Standards	ANSI SQL

SQL Server 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)
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)
HP Neoview	TIME(p), 00:00:00:000000 and 23:59:59:999999 (microseconds accuracy)
Ingres	TIME(p), 00:00:00 and 24:00:00

Related Data Types in SQL Server

Data Types
Datetime	DATE	DATETIME	DATETIME2	DATETIMEOFFSET	SMALLDATETIME

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres