Buradasın
SQL Server Time Data Type
learn.microsoft.com/en-us/sql/t-sql/data-types/time-transact-sql?view=sql-server-ver16Yapay zekadan makale özeti
- Basic Properties
- Time data type defines 24-hour clock without time zone awareness
- Precision can be integer from 0 to 7 (default 7)
- Minutes and seconds use two digits (0-59)
- Fractional seconds use digits (0-9999999)
- String Format
- Supports hh:mm[:ss][.fractional seconds][AM][PM] format
- AM/PM can be specified for hours 01-23
- Milliseconds can be specified with colon (:) or period (.)
- Midnight represented by 12:00 AM or 00:00
- Conversion Behavior
- Converts to other types by copying hour, minute, and seconds
- Converts to datetime sets date component to '1900-01-01'
- Converts to datetimeoffset sets time zone offset to +00:00
- Converts to datetime2 sets date component to '1900-01-01'
- Limitations
- ISO 8601 standards (24 for midnight, leap second) not supported
- Some down-level clients may not support time data type
- Conversion to date type fails with error 206