You can try below:
SELECT DateFromParts(Year(ModifiedDate), Month(ModifiedDate ), Day(ModifiedDate)) from Person.Person