[ad_1]
Like this:
Cast(create_date as date) as [Column Name Here]
You can omit the [] if you are not using spaces or reserved words in your column name (which is good practice anyway).
[ad_2]
solved Give an Alias to a column I’ve casted as a date [closed]