It doesn't matter how it looks like in a table, but it is important how it looks like when you retrieve a data. So, you can convert it into different formats inside any of your SELECT statement like that:

SELECT CONVERT(CHAR(10), HIREDATE, 111) or

SELECT CONVERT(CHAR(10), HIREDATE, 105)

instead of just SELECT HIREDATE