Adobe Flex MVC Pattern

Comparing date in SQLServer

DATEDIFF(DAY, START_DATE, END_DATE) = 0
AND
DATEDIFF(MONTH, START_DATE, END_DATE) = 0
AND
DATEDIFF(YEAR, START_DATE, END_DATE) = 0

Adding a Date to a date in SQL Server

DATEADD(DAY, No of days to add, date_to_which_days_are_added)




Example:



DATEADD(DAY, 1, START_DATE)