Interval Data Type Length
The following rules are used to determine the length of an interval data type in characters. Length is expressed in number of characters. The number of bytes depends upon the character set. The length includes the following values added together:
Two characters for every field in the interval that is not the leading field.
For the leading field, the number of characters that is the express or implicit leading precision. If the leading precision is not specified, the default value is 2.
One character for the separator between the fields.
One plus the express or implied seconds precision. If the seconds precision is not specified, the default value is 6.
Specific column length values for each interval data type are contained in Column Size.
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre