Quote:is there any way to change format date in sql server
It is a bad idea, use DATE data type , it specially crafted to handle dates and allow dates comparisons.
is date data type in your table, I would use:
select format(datee,'dd - MM - yyyy') from sale2 where datee > =DATE '2019-01-01' and datee <= getdate()
select datee from sale2 where datee > =DATE '2019-01-01' and datee <= getdate()
and let formatting be done accordingly to client local date format.
Dates and Times: Date and Time Literals