Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Comparison of DATE
- Thread starter Justyn
- Start date
.Hi,
Here is a sample query which will get the altest of two dates. The table used is employee table on sample database. Hope this helps.
DB2 "WITH TEMP AS (select case when (hiredate > birthdate) then 0 else 1 end as value from employee where empno = '000010') SELECT CASE VALUE WHEN 0 THEN HIREDATE ELSE BIRTHDATE END FROM TEMP,EMPLOYEE WHERE EMPNO='000010'"
Bye
GK
Here is a sample query which will get the altest of two dates. The table used is employee table on sample database. Hope this helps.
DB2 "WITH TEMP AS (select case when (hiredate > birthdate) then 0 else 1 end as value from employee where empno = '000010') SELECT CASE VALUE WHEN 0 THEN HIREDATE ELSE BIRTHDATE END FROM TEMP,EMPLOYEE WHERE EMPNO='000010'"
Bye
GK
- Status