Hi ,
I need a select query which has to be like below..
I have to start from the sysdate and to end upto last date of the current year.
for example sysdate is 23-oct-2013 means , have to add the digit of the date (2+3 = 5) and add those sum to that date. (23-oct-2013 + 5= 28-oct-2013)
The next date must be 28-oct-2013..
the series is as follows
23-oct-2013 [ i.e (2+3 = 5) + (23-oct-2013) = 28-oct-2013 ]
28-oct-2013 [ i.e (2+8=10) + (28-oct-2013) = 07-nov-2013 ]
07-nov-2013
.
.
.
.
.end of this year
kindly help me in this issue..
thanks in advance