Hive Unix Timestamp
<p>I'm not getting expected result from UNIX_TIMESTAMP of hive</p>

<p>For example :</p>

<pre><code>select FROM_UNIXTIME(UNIX_TIMESTAMP('2015/02/01', 'YYYY/MM/DD')) from table limit 1;
</code></pre>

<p><strong>OUTPUT :</strong></p>

<pre><code>2014-12-28 00:00:00
Time taken: 0.287 seconds, Fetched: 1 row(s)
</code></pre>

<p>I expected it to return 2015-02-01 , but it resulted something else. I understand its probably because of epoch time ? </p>