Post reply

greater than 30 days

  • October 5, 2011 at 8:27 am

    #248894

    How do I use datediff to make this line say greater than 30 days?

    agenttime >= '2011-09-05 12:12:01.000'

  • October 5, 2011 at 8:36 am

    #1390717

    So you want everthing before september 5th or evertything after that?

  • October 5, 2011 at 11:47 am

    #1390864

    Is this what you are looking for?

    DECLARE @agenttime TABLE

    (agenttime DATETIME)

    INSERT INTO @agenttime SELECT ('2011-09-05 12:12:01.000')

    INSERT INTO @agenttime SELECT ('2011-09-06 12:12:01.000')

    INSERT INTO @agenttime SELECT ('2011-09-04 12:12:01.000')

    SELECT *

    FROM @agenttime

    WHERE DATEDIFF(DD, agenttime, GETDATE()) >= 30

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply