Home Forums SQL Server 2008 SQL Server 2008 - General Remove time(date) RE: Remove time(date)

  • November 27, 2015 at 8:40 am

    #1842652

    jcachado (11/27/2015)

    Jeff Moden (11/27/2015)

    BrainDonor (11/27/2015)

    That was just an example, using a SQL Server date function.

    What does FORMAT(create_dtim,'dd-MM-yyyy')do?

    Just so you know, FORMAT is 44 times slower than either CAST or CONVERT.

    Thks for your help....still find the solution for me 🙁

    Regards,

    Cachado

    I don't even know how to spell "Informix". This is a Microsoft SQL Server site. As others have stated, you should probably look for an "Informix" site/forum to get help with this problem.

    --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)