I need some DB2 SQL help identifying accounts that had restrictions removed the previous day, then placed again the next day. Example below:
ACCT_NUM START_DT END_DT
10019220 02-28-2013 04-08-2013
10019220 04-09-2013 04-29-2013
The restriction end_dt is 4/8/2013, and the next day (start_dt 4/9/2013), it was placed on the account.
What date function/code snippet do I use to identify only this scenario above?