Post reply

Date format problems

  • May 17, 2004 at 4:06 am

    #108251

    Hi

    This has got me quite confused.  

    Getting the following error from a very simple query :

    Error opening Data Source:  ERROR [22007][Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

    This is the query.

    SELECT SUM(md_value ) FROM mi_data join data_items ON md_di_id = di_id WHERE di_dt_id =  6 AND datediff(day, md_date, '16/05/2004' ) = 0 

    Now I'm not connecting to the db via QA, but another query builder.  The weird thing is that it works fine on a colleagues machine (aslo with the other query builder)!?!  Checked the ODBC settings and they all match. 

    Any ideas?

    Thanks

    Ritch

     

     


    "I didn't do anything it just got complicated" - M Edwards

  • May 17, 2004 at 4:30 am

    #506605

    Hi,

    After a caffiene injection, found the answer (couldn't see the wood for the trees).

    Set DATEFORMAT dmy

    Thanks

    Ritch


    "I didn't do anything it just got complicated" - M Edwards

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

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