So, what have you tried? And what's not working?
Please post your data in a format we can apply to our own databases and use (such as CREATE TABLE and INSERT statements, or a WITH clause)
try something like this:
where <your_date_column> >= DATE ('20.06.2014')
and <your_time_column> >= TIME ('16:00:00')
This works on my db2, but i'm from Germany, perhaps you have to check these statements in your db2 system:
select TIME ('16:00:00') from sysibm.SYSDUMMY1
select DATE ('20.06.2014') from sysibm.SYSDUMMY1
Thanks,Irrespective of database the logic for retrieving data is same .Please leave it if you don't have the logic.
Please respect that fact that you're asking a moderator and Oracle expert to leave. I think you need to look at just what you're asking.
You don't go into a BMW garage and ask them to supply you with parts for a Citroen, so why come to an Oracle forum and ask for help with your DB2 issue?
There are huge differences between different database engines and the SQL syntax used in one does not necessarily work in another.
If I supply the logic for you in Oracle syntax, the chances are that it's not going to work for you on DB2. Does DB2 have a "to_date" function? Does it understand the same date formats that Oracle uses e.g. MI meaning minutes, rather than MM?
Your are ill informed if you think the 'logic' for retrieving data is the same. It's not.
You also failed to show what queries you'd tried yourself and demonstrate what wasn't working. That's just rude. People are not here to do your work for you; and you should at least show that you've had a go at trying to do it yourself. That's just a common courtesy of using technical forums, here at Oracle or elsewhere.