Database

SELECT value FROM v$nls_parameters WHERE parameter ='NLS_DATE_FORMAT';

SELECT * FROM branch 
WHERE DATEDIFF('dd', GETDATE(), EndDate) = ContractReminder 
OR DATEDIFF ('dd', GETDATE(), EndDate) = ReminderType * 30

SELECT BranchName, ContractNo, Email, StartDate, EndDate, 
    CASE
-- notice that the 101 is my favorite see BOL Convert for list of others
        WHEN CONVERT(VARCHAR, DATEADD(day, ContractReminder, GETDATE()), 101) > EndDate 
                 THEN 'Less than ' + CAST(ContractReminder as VARCHAR) + ' days left'
        WHEN CONVERT(VARCHAR, DATEADD(month, remindertype, GETDATE()), 101) > EndDate 
                 THEN 'Less than ' + remindertype + ' months left'
    END AS MyFlag  
INTO #RList 
WHERE CONVERT(VARCHAR, DATEADD(day, ContractReminder, GETDATE()), 101) > EndDate 
    OR CONVERT(VARCHAR, DATEADD(month, remindertype, GETDATE()), 101) > EndDate 

select branchname, contractno, email, startdate, enddate, contractreminder, remindertype
from branch
where convert(varchar(20), enddate,112) = convert(varchar920), dateadd(dd, contractreminder, current_timestamp),112)  
      -- this will then removes the issues of the times in the datetime column

select top 1 productid, u_price, qc_dt
from (select productid, u_price, qc_dt
      from qc
      where productid = 1011
      order by qc_dt desc) z