"in" problem in DB2

mandla.srinivas · #1 (**permalink**) 01-05-07, 11:57

Thanks Rahul for your previous answer

SELECT * FROM TFCT_CNTCT where date(TFCT_CNTCT.STRT_DT)
in
(
'01/05/2007', '01/04/2007'
)
is getting executed and giving results

------------------------------------------------------

but the following statement is not giving results.

SELECT * FROM TFCT_CNTCT where date(TFCT_CNTCT.STRT_DT)
in
(
select current date,current date -1 day from sysibm.sysdummy1
)

you could send me the answers to mandla.srinivas@gmail.com

Marcus_A · #2 (**permalink**) 01-05-07, 12:23

Try this:

SELECT * FROM TFCT_CNTCT where date(TFCT_CNTCT.STRT_DT)
in
(
select current date from sysibm.sysdummy1
UNION ALL
select current date -1 day from sysibm.sysdummy1
)

mandla.srinivas · #3 (**permalink**) 01-05-07, 12:32

thank you very much Marcus

n_i · #4 (**permalink**) 01-05-07, 17:04

or

Code:

SELECT * FROM TFCT_CNTCT where date(TFCT_CNTCT.STRT_DT)
in (values current date, current date -1 day)

Peter.Vanroose · #5 (**permalink**) 01-07-07, 08:13

or even

Code:

SELECT *
FROM   TFCT_CNTCT
WHERE  date(STRT_DT) in (current date, current date - 1 day)

Internet Services

Web Development

Digital Marketing

Consumer Tech