title: Convert Gregorian Date to Julian
body: <p>Hi I am trying to create a function for Gregorian to Julian date &amp; Julian to Gregorian so that i can use these in reports/queries/vbs scripts in the future without having to include this in everything moving forward. This is for an oracle database and the gregorian date format we are using is ddmmyyyy. I have tried to use the following below which returns todays julian date but am having no luck so far converting from greg to julian. </p>
  
  <pre><code>select sysdate, to_char(sysdate,'YDDD') "YDDD" from dual;
  </code></pre>