title: In SQL Server how to have a paymentdate greater than the month and year ignoring the day part?
body: <p>In Oracle:</p>
  
  <pre><code>select 
      name, 
      case 
         when PaymentDate is not null 
              and PaymentDate &lt;= to_date('202001','yyyyMM')
            then 'Paid'  
            else NotPaid
  where 
      empId  in(%s)) ;
  </code></pre>
  
  <p>I need the SQL Server equivalent of the above query. I just need to check the month and year part of the date with paymentdate's month and year. Please advice.</p>
  
  <p>Need the <code>to_date('202001','yyyyMM')</code> equivalent in SQL Server.</p>