You are loading a fact table into a Fabric warehouse. The source column OrderTimestamp arrives as a VARCHAR value like '2024-03-15T09:42:11'. Analysts need a proper DATE column named OrderDate (no time component) so they can join to a date dimension and group by day. Which T-SQL expression correctly produces the OrderDate value?