The internal storage of a SMALLDATETIME value

Posted by Peter Larsson on SQL Team See other posts from SQL Team or by Peter Larsson
Published on Fri, 05 Nov 2010 14:14:30 GMT Indexed on 2010/12/06 16:58 UTC
Read the original article Hit count: 495

SELECT  [Now],

        BinaryFormat,

        SUBSTRING(BinaryFormat, 1, 2) AS DayPart,

        SUBSTRING(BinaryFormat, 3, 2) AS TimePart,

        CAST(SUBSTRING(BinaryFormat, 1, 2) AS INT) AS [Days],

        DATEADD(DAY, CAST(SUBSTRING(BinaryFormat, 1, 2) AS INT), 0) AS [Today],

        SUBSTRING(BinaryFormat, 3, 2) AS [Ticks],

        DATEADD(MINUTE, CAST(SUBSTRING(BinaryFormat, 3, 2) AS SMALLINT), 0) AS Peso

FROM    (

            SELECT  CAST(GETDATE() AS SMALLDATETIME) AS [Now],

                    CAST(CAST(GETDATE() AS SMALLDATETIME) AS BINARY(4)) AS BinaryFormat

        ) AS d

 

 

© SQL Team or respective owner