Convert date into individual numerical columns for year month and day SQL
<p>I have a date column in the format <code>YY-MON-DD</code>, e.g. <code>25-JUN-05</code>. Is it possible to isolate this into 3 separate columns for year, month and day? Where month is converted from text to numerical, e.g. Year: <code>25</code>, Month: <code>06</code>, Day: <code>05</code>?</p>