select sale_date, convert(date,sale_date ) As Sale_updated_date from PortFolioProject.dbo.Retail_Sales_Analysis select sale_time, convert(time,sale_time ) As Sale ...