[Solved] Give an Alias to a column I’ve casted as a date [closed]

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).