title: How to determine days count on the current year using a certain date on ORACLE SQL dual table
body: <p>For example, date with YYYYMMDD as a format and considering the leap year as well</p>
  
  <p>20160201 is the 32 day of the year</p>
  
  <p>20160226 is the 57 day of the year</p>
  
  <p>20161231 is the 366 day of the year</p>