title: Extracting substring from a string in Hive
body: <p>I have a date column. The dates are in format <code>M/d/yyyy hh:mm:ss</code> or <code>MM/d/yyyy hh:mm:ss</code> or <code>M/dd/yyyy hh:mm:ss</code> or <code>MM/dd/yyyy hh:mm:ss</code>
  I want to convert these dates in <code>yyyy-MM-dd</code> format. How can I achieve it in Hive?</p>