Can you please explain the concept for timestamp(0),timestamp(1) ....timestamp(6)..?
Thanks in advance for the help.
Can you please explain how the timestamp value internally stores? and how much space timestamp(0) will occupy?
I read below two statements in SQL doc.
1. Timestamp column takes 10 bytes space.
Date --> 4 bytes
Time --> 6 bytes
2. Timestamps represented as character strings must be syntactically precise and may take a maximum of twenty six bytes of storage.
Timestamp Format Character conversion
TIMESTAMP(0) ‘2001-12-07 11:37:58’ CHAR(19)
TIMESTAMP(6) ‘2001-12-07 11:37:58.213000’ CHAR(26)
what is the difference between statement1 and statement2?