Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jano Petras Get DATE part of the DATETIME RE: Get DATE part of the DATETIME

  • June 14, 2011 at 9:59 am

    #1338495

    Our inhouse method of doing this for today's date is:

    DATEDIFF(d, 0, GETDATE())

    or for a general date from the DB:

    DATEDIFF(d, 0, DateField)

    DATEDIFF may be more expensive, but is it more expensive than "CAST(FLOOR(CAST("?