I have i/p records as below
col1 col2 col3 col4
1 a 2000-01-01 2000-01-06
2 b 1999-09-09 1999-09-12
my o/p should be
col1 col2 col3 col4
1 a 2000-01-01 2000-01-02
1 a 2000-01-02 2000-01-03
1 a 2000-01-03 2000-01-04
1 a 2000-01-04 2000-01-05
1 a 2000-01-05 2000-01-06
2 b 1999-09-09 1999-09-10
2 b 1999-09-10 1999-09-11
2 b 1999-09-11 1999-09-12