Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

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

All Data Types

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.