title: Convert number in Julian format 'yyyyddd' to Date
body: <p>How do I convert a numeric in Julian format 'yyyyddd' to a proper Date value in Teradata?
  For example from '2014001' to '2014-01-01'.</p>
  
  <p>Please provide two examples, first when '2014001' is a numeric and second when it is a character.</p>
  
  <p>Many Thanks!</p>