Professional Web Applications Themes

Arthimetic overfilow - Microsoft SQL / MS SQL Server

Could anybody please answer me on this query: SELECT * FROM DBName..TableName where CONVERT(DATETIME,(CONVERT(CHAR(8),((CONVERT (INT,CONVERT(CHAR(8),XyzDate,112))) - XyzDateset)))) = '2002/11/14' and convert(varchar,XyzDate) not like '20000214.%' It returns: Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. Thank you Dave...

  1. #1

    Default Arthimetic overfilow

    Could anybody please answer me on this query:

    SELECT * FROM DBName..TableName
    where CONVERT(DATETIME,(CONVERT(CHAR(8),((CONVERT
    (INT,CONVERT(CHAR(8),XyzDate,112))) -
    XyzDateset)))) = '2002/11/14' and convert(varchar,XyzDate)
    not like '20000214.%'

    It returns:

    Server: Msg 241, Level 16, State 1, Line 1
    Syntax error converting datetime from character string.

    Thank you
    Dave

    Dave R. Guest

  2. #2

    Default Re: Arthimetic overfilow


    "Dave R." <romeoinushotmail.com> wrote in message
    news:0c7801c34726$18ab8890$a001280aphx.gbl...
    > Could anybody please answer me on this query:
    >
    > SELECT * FROM DBName..TableName
    > where CONVERT(DATETIME,(CONVERT(CHAR(8),((CONVERT
    > (INT,CONVERT(CHAR(8),XyzDate,112))) -
    > XyzDateset)))) = '2002/11/14' and convert(varchar,XyzDate)
    > not like '20000214.%'
    >
    > It returns:
    >
    > Server: Msg 241, Level 16, State 1, Line 1
    > Syntax error converting datetime from character string.
    >
    That query is trash.

    It's not worth figuring out.

    Throw it away, figure out what the query is supposed to do and rewrite it
    using datediff, dateadd etc.

    If you have trouble, post DDL and an explanation of what you need, and
    you'll get help.

    David


    David Browne Guest

  3. #3

    Default Re: Arthimetic overfilow


    "Jaime E. Maccou" <jemaccouhotmail.com> wrote in message
    news:03b601c347ea$84653350$a301280aphx.gbl...
    > Hey , not so rough everyone has to start somewhere.
    > >-----Original Message-----
    > >
    I was assuming the poster was trying to fix someone else's query.
    If not, I appologize, that was rude.


    Anyway I can't tell what it's trying to accomplish.

    David


    David Browne Guest

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139