• I reckon it's somewhere around your DOB, Lowell 😛

    SELECT *

    FROM (SELECT ticks = 624511296000000000) z

    CROSS APPLY (SELECT microseconds = z.ticks/100) a

    CROSS APPLY (SELECT milliseconds = a.microseconds/1000) b

    CROSS APPLY (SELECT [seconds] = b.milliseconds/1000) c

    CROSS APPLY (SELECT [minutes] = c.[seconds] / 60) d

    CROSS APPLY (SELECT [hours] = d.[minutes] / 60) e

    CROSS APPLY (SELECT [days] = e.[hours] / 24) f

    CROSS APPLY (SELECT startdate = DATEADD(DD,0-f.[days],GETDATE())) g


    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].


    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]