DB2 Select Question

sandyin1 · #1 (**permalink**) 03-25-11, 06:03

ppl,

I need some help regarding a DB2 select statement - I have three fields in a table like this

YEAR CHAR(4) N 2011
MONTH CHAR(2) N 01
DAY CHAR(2) N 01

I need to select data between 2 dates. I tried giving this but it said no rows found . How should i do this

WHERE ("YEAR" > '2011'
AND "MONTH" > '01'
AND "DAY" > '01' )
AND ("YEAR" < '2011'
AND "MONTH" < '03'
AND "DAY" < '01' )
FOR FETCH ONLY WITH UR

tonkuma · #2 (**permalink**) 03-25-11, 06:21

How about these samples?

Sample1:

Code:

 WHERE (    YEAR  > '2011' 
        OR
            YEAR  = '2011'
        AND MONTH > '01'
        OR
            YEAR  = '2011'
        AND MONTH = '01'
        AND DAY   > '01'
       )
   AND (    YEAR  < '2011' 
        OR
            YEAR  = '2011'
        AND MONTH < '03' 
        OR
            YEAR  = '2011'
        AND MONTH = '03' 
        AND DAY   < '01'
       )

or

Sample2:

Code:

 WHERE YEAR || MONTH || DAY
       BETWEEN '20110102'
           AND '20110228'

sandyin1 · #3 (**permalink**) 03-25-11, 07:29

Thanks a Lot

Internet Services

Web Development

Digital Marketing

Consumer Tech