Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gianluca Sartori Dealing with custom date formats in T-SQL RE: Dealing with custom date formats in T-SQL

  • March 23, 2012 at 6:37 pm

    #1463872

    Lisa Slater Nicholls (3/23/2012)

    charles.southey (3/23/2012)

    Yes - it's relevant to the article and provides a possible solution for those grappling with the problem under discussion that they may be looking for. We would never post something that is not directly relevant. Not everyone wants a commercial solution - but I think it's worth knowing that it's there if you do. BTW the product is perpetually free for use on Developer Edition.

    OK, Charles, since you're here with your potential solution... how does your product stack up against the author's custom CLR function and the rest?

    When doing exactly the task(s) described in the article, how long does it take?

    I'm sure there are other potential comparisons (flexibility, ease of use, etc), and if you discussed those here I'd consider it an advertisement for sure.

    But speed is really a comparison that would add to this conversation, IMHO, without being an "ad". The perf disparity between FORMAT() and the custom function is very interesting and has made me very curious. Is there some general pattern here, what can we learn?

    Thanks in advance,

    >L<

    Oh My! 🙂 There's another "me" out there! I was going to ask Charles for his performance stats on 10,000, 100,000, and 1 million rows of dates and even offer to build the test table for him. Well done, Lisa!

    The only bad part about Charles doing the testing is having the proverbial mouse guard the cheese. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)