title: Convert Julian Date to Normal Date in Node.js for IBM DB2 iSeries
body: <p>In one of my application development I am using IBM DB2 iSeries database connected with DataDirect technology given by Progress with db2.jar. In database the date stored as 7 digit Julian format that I have to convert in normal date as timestamp in Node.js as my data layer has been implemented in Node.js that has to deploy on Apigee. 
  I need a generic solution that can convert this julian date to normal date at SQL query level as well as in Node.js</p>
  
  <p>Example of Julian date is 1160920 this is corresponds to 2016-09-20.</p>