25112
asked on
DATEDIFF -- dd vs yy
is
DATEDIFF(yy, COLUMN1, COLUMN2 ) <=1
exactly same as
DATEDIFF(dd, COLUMN1, COLUMN2 ) <=365)
DATEDIFF(yy, COLUMN1, COLUMN2 ) BETWEEN 1 and 2
exactly same as
DATEDIFF(dd, COLUMN1, COLUMN2 ) BETWEEN 366 and 730
DATEDIFF(yy, COLUMN1, COLUMN2 ) <=1
exactly same as
DATEDIFF(dd, COLUMN1, COLUMN2 ) <=365)
DATEDIFF(yy, COLUMN1, COLUMN2 ) BETWEEN 1 and 2
exactly same as
DATEDIFF(dd, COLUMN1, COLUMN2 ) BETWEEN 366 and 730
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
helped - thanks
ASKER
SELECT DATEDIFF(yy, '2011/01/01', '2012/12/12' )
does not look days but only the year part?