Search results
-
S
convert start and end dates to corresponding months
Dear Friends......I have the data like:- Emp_ID Start_Date End_Date Pay_Due Pay_Drawn ===== ======== ======= ======= ======== 101 07-APR-2008 31-JAN-2009 15000 12000 101 01-FEB-2009 20-MAR-2009 20000 17000 102 01-FEB-2008 15-APR-2009 10000 90000 Each employee can have multiple lines in the... -
S
Query: Split the Start_Date and End_Date to corresponding Months
Dear Friends......I have the data like:- Emp_ID Start_Date End_Date Pay_Due Pay_Drawn ===== ======== ======= ======= ======== 101 07-APR-2008 31-JAN-2009 15000 12000 101 01-FEB-2009 20-MAR-2009 20000 17000 102 01-FEB-2008 15-APR-2009 10000 90000 Each employee can have multiple lines in the...