Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Performance Test of New Date Manipulation Functions (SQL Spackle) RE: Performance Test of New Date Manipulation Functions (SQL Spackle)

  • May 10, 2012 at 7:35 am

    #1485694

    I don't get how DATETIMEFROMPARTS can tell if I want the first day of the quarter, or the first day of a month based on the portion of the article that has

    SELECT SomeDate,

    DATETIMEFROMPARTS(ca.Yr, 1, 1, 0, 0, 0, 0) AS [FirstDayOfYear],

    DATETIMEFROMPARTS(ca.Yr, ca.Mth, 1, 0, 0, 0, 0) AS [FirstDayOfMonth],

    DATETIMEFROMPARTS(ca.Yr, ca.Qtr, 1, 0, 0, 0, 0) AS [FirstDayOfQuarter],

    DATETIMEFROMPARTS(ca.Yr, ca.Mth, ca.Dy, ca.Hr, 0, 0, 0) AS StartOfHour,

    DATETIMEFROMPARTS(ca.Yr, ca.Mth, ca.Dy, ca.Hr, ca.Mn, 0, 0) AS StartOfMinute,

    DATETIMEFROMPARTS(ca.Yr, ca.Mth, ca.Dy, ca.Hr, ca.Mn, ca.Sec, 0) AS StartOfSecond

    In the 3rd line you pass in an integer from the Quarter, but every other time it's the month.

    What did you do with the quarter line that lets DATETIMEFROMPARTS know that it's using a quarter instead of a month?

    I mean if I run

    SELECT DATETIMEFROMPARTS(2012, 3, 1, 0, 0, 0, 0) AS [FirstDayOfQuarter]

    Is that 2012-03-01 or is it 2012-07-01 ?


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]