Q

Comparing dates

This Content Component encountered an error
I am new to DB2, and I want to compare two dates, i.e., posted date with the expiry date. If posted date is more than seven days old, I need to archive that topic. Or if the current date is greater than expiry date, I need to archive that topic. How can I do the date comparisons in DB2? Is there any DB2-specific function for date comparisons?

DB2 offers a wealth of functionality in terms of its date/time arithmetic support and date/time functions. I suggest you take a look at the "DB2 SQL Reference" manual available for download from IBM's Web site to read up on DB2's date/time support. To answer your specific question, though, the following query/predicate should return the rows where the posted date is greater than 7 days from the expiry date:

SELECT COL1, COL2, ... 
FROM   YOUR_TABLE 
WHERE (POSTED_DATE + 7 DAYS) > EXPIRY_DATE; 

This was first published in January 2003

Dig deeper on IBM DB2 management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close