Home Forums SQL Server 2005 T-SQL (SS2K5) Modify date to first day of week,month,quarter RE: Modify date to first day of week,month,quarter

  • June 21, 2010 at 2:06 pm

    #1182971

    loki1049 (6/21/2010)

    Now the issue: This doesn't seem to work with using the 'week' period.

    DateDiff is counting the # of boundaries crossed. In the "datepart Boundaries" section, it implies that calandar weeks are used for the week datepart.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2