Date format in hive
<p>table has DEPNO   DATE            it contains 2 records as :
           1      2004-05-02
           2      03-APR-04 
I want to process above 2 records dates in in yyyy-mm-dd format in hive </p>