title: How to write my Oracle Query to SQL Server
body: <p>This is my Oracle query:</p>
  
  <pre><code>SELECT 
      To_char(( Trunc (Next_day (SYSDATE, 'SUN')) - 21 ), 'dd-Mon-yy'), 
      To_char(( Trunc (Next_day (SYSDATE, 'SUN')) ), 'dd-Mon-yy'), 
      To_char(SYSDATE, 'dd-Mon-yy') 
  FROM   dual 
  </code></pre>
  
  <p>How to write this query in SQL Server Management Studio? Can anyone help me?</p>