Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721

    Unanswered: Functionality of DATEPART

    Functionally, is there any difference between DATEPART for m, d, and yyyy, verses simply using MONTH, DAY, and YEAR functions respectively?

    For all intents and purposes, they seem identical, so is there any performance considerations using one verses another?
    Last edited by Seppuku; 05-12-04 at 17:43.
    That which does not kill me postpones the inevitable.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't know of any material difference between them.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •