title: select records of date column of value (query executed day + 2 days)
body: <p><a href="https://i.stack.imgur.com/JbJlP.png" rel="nofollow noreferrer">This is the result I was expecting</a>[
  I have a table T1 with 2 columns NAME &amp; DT as shown in figure</p>
  <pre><code>CREATE TABLE T1 ( NAME VARCHAR2(1), DT TIMESTAMP(3) ); 
  
  INSERT INTO T1 VALUES ( ‘A’ , TO_TIMESTAMP(‘2021-02-13 12:00:00.000000000’, ‘YYYY-MM-DD HH24:MI:SS.FF’)); 
  
  INSERT INTO T1 VALUES ( ‘B’ , TO_TIMESTAMP(‘2021-02-14 12:00:00.000000000’, ‘YYYY-MM-DD HH24:MI:SS.FF’)); 
  
  INSERT INTO T1 VALUES ( ‘C’ , TO_TIMESTAMP(‘2022-03-18 12:00:00.000000000’, ‘YYYY-MM-DD HH24:MI:SS.FF’));
  
  INSERT INTO T1 VALUES ( ‘D’ , TO_TIMESTAMP(‘2022-03-19 12:00:00.000000000’, ‘YYYY-MM-DD HH24:MI:SS.FF’)); 
  </code></pre>
  <p>After executing above query, data gets populated and I want to select the records in such a way that if I run the query today in particular year, it needs to select the date which has DT value <strong>(sysdate + 2)</strong>.</p>
  <p>For example:</p>
  <p>I have data in table T1 shown in pic, today's date is <strong>12th feb 2021</strong>...If I run query today, I need to get records having DT value of <strong>14th Feb 2021</strong>. In present year, I will run the query on <strong>12th Feb 2021</strong>, I need to select all the records having DT values of <strong>2021 year</strong> and then select the records having DT of value <strong>14th feb 2021.</strong></p>
  <p>In the same way, if I run the same query on next year let us say, I ran the query on <strong>17th march 2022</strong>, I need to get the records having DT value of <strong>19th March 2022</strong>. In next year, I will run the query on <strong>17th March 2022</strong>, I need to select all the records having DT values of <strong>2022 year</strong> and then select the records having DT value of <strong>19th March 2022</strong>.</p>
  <p>I was not getting idea what query I need to write in <strong>WHERE CLAUSE</strong> and query should be same and need to execute same query in all years</p>
  <p>]<a href="https://i.stack.imgur.com/URL0y.png" rel="nofollow noreferrer">2</a></p>