s/CAST(CAST(hs_date AS DATE FORMAT …
      ^    ^