title: Convert Bigint to Date in PostgreSQL
body: <p>Hi I have a BigINT column with value for ex : 20140130. This need to be converted to a date column 2014/01/30 format yyyy/MM/dd using PostgreSQL</p>
  
  <p>please tell how this can be done ?</p>