FIGURE 3: Code to Display Data in Days and Clock Ticks

DECLARE @now datetime, @bytenow binary(8)
SELECT @now = getdate()
SELECT @bytenow = convert(binary(8), @now)
SELECT @now AS fulldate, @bytenow AS internal,
       convert(int, substring(@bytenow, 1, 4)) AS days,
       convert(int, substring(@bytenow, 5, 8)) AS ticks


Results:
fulldate                    internal           days        ticks   

----------------------------- ------------------ ---------- ------------

2000-06-08 21:43:04.430     0x00008F4B0165E661 36683       23455329