Write SQL query to solve given problem: Between 1/1/2012 to 12/31/2014, which date recorded the hottest temperature in weather station 1?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT `date` FROM weather WHERE station_nbr = 1 AND CAST(SUBSTR(`date`, 1, 4) AS int) BETWEEN 2012 AND 2014 ORDER BY tmax DESC LIMIT 1