Post reply

char to datetime

  • May 28, 2007 at 9:48 am

    #116979

    hi guys,

    i'm getting the following error while trying to convert from cahr to datetime

    The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

    any help please

    thx much

     

  • May 28, 2007 at 10:42 am

    #709212

    We can only guess unless you provide the formula in the query and some sample data.

    Here's my guess... you have something in the CHAR column that doesn't translate to a date.  Use ISDATE to find it.

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

  • May 28, 2007 at 1:52 pm

    #709219

    And read "Cast and convert" topic in BOL.

    _____________
    Code for TallyGenerator

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply