title: Convert yyyymmdd(int type) to date
body: <p>I need to use <a href="http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_week" rel="nofollow">WEEK</a> function so I need a <strong>date</strong> type. </p>
  
  <p>While what I have in db is a <strong>int</strong> type like 20150101 representing 1st,Jan 2015. </p>
  
  <p>I tried <code>FROM_UNIXTIME</code> but obviously it is not I want:</p>
  
  <pre><code>select FROM_UNIXTIME(20150101) from dual;
  +-------------------------+
  | FROM_UNIXTIME(20150101) |
  +-------------------------+
  | 1970-08-22 14:15:01     |
  +-------------------------+
  </code></pre>
  
  <p>Do I have a way to convert the yyyymmdd(int) to a date type?</p>