Welcome to Sign in | Help
Search
Home Blogs External Feeds Forums Photos Downloads About Us
» Romanian Section » Intrebari » T-SQL » Re: Problema cu date

Re: Problema cu date

  •  03-26-2010, 12:08 PM

    Re: Problema cu date

    Reply Quote
    Punctul de plecare este aici.

    DECLARE @pData DATETIME = GETDATE()

    DECLARE @primaZi DATETIME = DATEADD(MONTH,DATEDIFF(MONTH,0,@pData),0)
    DECLARE @ultimaZi DATETIME = DATEADD(MONTH,DATEDIFF(MONTH,-1,@pData),-1)


    ;WITH DateTest(Data)
    AS
    (
    SELECT '2010-01-31'
    UNION ALL
    SELECT '2010-02-20'
    UNION ALL
    SELECT '2010-03-15'
    UNION ALL
    SELECT '2010-04-25'
    )
    SELECT @pData AS DataReper,
      D1.Data AS DataStart,
      D2.Data AS DataStop,
      CASE WHEN D1.Data <= @primaZi AND @ultimaZi <= D2.Data THEN 'DA' ELSE 'NU' END AS RezultatTest
    FROM DateTest AS D1 CROSS JOIN DateTest AS D2
    WHERE D1.Data < D2.Data
    ORDER BY D1.Data, D2.Data
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems