DB2 help in sysdate

vivek.vivek · #1 (**permalink**) 01-22-09, 03:20

Please help me to convert the ststement:

select count(Test.Batch_Name) as count1 from Test where Test.Batch_name='BATCH_0001' and sysDate < (select Batch.Batch_End_Date from batch where Batch.Batch_Name='BATCH_0001') and sysDate > (select Batch.Batch_Start_Date from batch where Batch.Batch_Name='BATCH_0001')

Instead of sysdate i used current date. But its showing null result in DB2.
In oracle it is showing count as 15.

Thanks in Advance
Vivek

nick.ncs · #2 (**permalink**) 01-22-09, 03:38

sysDate is in oracle....the alternative for the same in db2 is CURRENT_TIMESTAMP so your sql script will change to

Quote:

SELECT count (Test.Batch_Name) AS count1
FROM Test
WHERE Test.Batch_name = 'BATCH_0001'
AND CURRENT_TIMESTAMP < (SELECT Batch.Batch_End_Date
FROM batch
WHERE Batch.Batch_Name = 'BATCH_0001')
AND CURRENT_TIMESTAMP > (SELECT Batch.Batch_Start_Date
FROM batch
WHERE Batch.Batch_Name = 'BATCH_0001')

also check the data in both systems

tonkuma · #3 (**permalink**) 01-22-09, 03:38

(I will delete.)

vivek.vivek · #4 (**permalink**) 01-22-09, 03:49

Ok.Thank You. it is working

Internet Services

Web Development

Digital Marketing

Consumer Tech