for example:
Table = Emp
Column = Hire_Date (Date Type)

SELECT MAX(Hire_Date - 1) FROM Emp;



F.