SQL - Strip Time From DateTime Type

Note To Self :

To strip the time element from a field defined as a datetime use

CAST(FLOOR(CAST($FIELD_NAME AS FLOAT)) AS DATETIME)

End......