title: How to convert string to date format when string has only two digits for a year (Oracle, Netezza)
body: <p>I have this issue databases: on Oracle and Netezza.</p>
  
  <p>ISSUE: I have a string: 16101211213. This string means: YYMMDDHH24MMSS. I need to convert it to date format YYYY-MM-DD HH24:MM:SS. So on the way I need to add the two digits (in front of the string). I know that dates are for XXI century. So I need to 20 at the begining.So in result I should get 2016-10-12 21:12:13</p>
  
  <p>Can anybody help me with it? I have tried many options (mainly on Netezza) but could not figure it out.</p>
  
  <p>Thanks a lot in advance!</p>