• Yes, they are equally safe.

    The DATEDIFF(day, 0, GETDATE()) calculates the number of days passed since day Zero, which is January 1, 1900. This is what clips the time information.

    These number of days I then add to the day Zero with DATEADD

    DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)

    The red part calculates the number of days passed since day Zero and the green part then adds this number of days to day Zero, which gives us the day we started with, and the time information clipped.

    This is convenient since I don't convert datetime into any other data type.


    N 56°04'39.16"
    E 12°55'05.25"