can any one give solution for my question
i have a table called leave balanced(leave-id,leave balance,etc are column),in leave balance column each employee has some leave balance (like 4,5,8 etc)i need to add this leave-balance to another column(that also have common value like 25) i need to update this new column based on system time at the end of 31st December at 12.00am.
You can't ask the database to update the value at the end of month. Instead write a program and then run it at 31st December 12.00am and then execute the following query:
update leave_balance set newcolumn=leave balance;
You can also run the program through Quartz scheduler or cron job scheduler.