Advertisement
Guest User

Untitled

a guest
Oct 6th, 2015
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.53 KB | None | 0 0
  1. SQL> SELECT * FROM test;
  2.  
  3. MENO            DEN_A_MESIAC_NA
  4. --------------- ---------------
  5. Jozko           29.12
  6. Ferko           2.1
  7.  
  8. SQL> SELECT * FROM test
  9.   2  WHERE to_date(den_a_mesiac_nar, 'DD.MM') BETWEEN to_date('28.12.2015', 'DD.MM.YYYY') AND to_date('4.1.2016', 'DD.MM.YYYY')
  10.   3  OR add_months(to_date(den_a_mesiac_nar, 'DD.MM'), 12) BETWEEN to_date('28.12.2015', 'DD.MM.YYYY') AND to_date('4.1.2016',  DD.MM.YYYY');
  11.  
  12. MENO            DEN_A_MESIAC_NA
  13. --------------- ---------------
  14. Jozko           29.12
  15. Ferko           2.1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement