Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Java-Beginners updating column automatically based on system date
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Neo Java Developer
updating column automatically based on system date
1 Answer(s)      4 years and 2 months ago
Posted in : Java Beginners


hi,

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.


Advertisement
View Answers

October 21, 2010 at 4:19 PM


Hi,

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.

Thanks



Related Tutorials/Questions & Answers:
updating column automatically based on system date
updating column automatically based on system date  hi, can any one...(that also have common value like 25) i need to update this new column based on system...,leave balance,etc are column),in leave balance column each employee has some leave
How automatically calculate age based on date of birth and current date using jsp and servlet?
How automatically calculate age based on date of birth and current date using jsp and servlet?  when user enters the Date of birth in one textbox then automatically age will be display on another textbox. event:Onlick Event
Advertisements
How to send Email automatically On Daily Basis Using Systems Date.
How to send Email automatically On Daily Basis Using Systems Date.  Hello Sir, I am working on a project in which i have to send emails automatically based on system dates with attchements .Kindly give me the code
Web-based system development
Web-based system development  I have a system written in java application.my lecturer asks me to do in web-base. what should i do?what should i have and what should i know? i have read that the best architecture is 3-tier
how to get current date without system date
how to get current date without system date  is there any possiblity to get current date instead of system date in Java, as i dont want to change date in program and if i change date in OS automatically change in program also
How to automatically change the value of the textbox based on the dropdown list?
How to automatically change the value of the textbox based on the dropdown list?  I want to know how to automatically change the value of price...'}); $('#inlineDatepicker').datepick({onSelect: showDate}); }); function showDate(date) { alert
Flash based Chat System - WebSevices
Flash based Chat System  Hi I would like to ask is it advisable putting the chat inside the Flash (integrated with the video), or putting it outside the the Flash using XMPP embedding in a website. What issues / pros
Need to get the Data based on Date
Need to get the Data based on Date  Hie , I am having a criteria where i need to get the data based on date . I have written the query as "from Balance as b where b.date like ?" But the date field in DB is in datetime2 format
getting current date without using system date - Date Calendar
getting current date without using system date  I want to get the current date but the Java code should not get System date as Current date. Pleae help me in getting current date without using system date. thanks in Advance
multimodal biometric system based on palmprint and iris
multimodal biometric system based on palmprint and iris  sir, i need a source code for my project "fusion technique of palmprint and iris using LBP and Fractal Analysis method
Space based web-hosting system
Space based web-hosting system Here, space based web hosting system refers.... The different types of space based web hosting system perform differently on the web. We.... Most servers are based on the Linux operating system and LAMP (software bundle
how to take system date in java servlet?????
how to take system date in java servlet?????  how to take system date in java servlet?????   Hi Friend, Try the following code: import... = System.currentTimeMillis(); Date date = new Date(time
Retrieve records based on date - Development process
Retrieve records based on date  Hi,In the following code i want to retrieve records between dates. Also want to search records based on sub-dept , but not working . Plz send code for that. Insernew.jsp(connecting database
web based java application for Leava and Payroll management system
web based java application for Leava and Payroll management system  Hello Team Good Morning, Can any one please help me with the source code for web based java application for Leava and Payroll management system. Thank you
JSP:How to get year of system date - Date Calendar
JSP:How to get year of system date  Please tell me how to get year of system date; I am doing import java.util.*; Date d = new Date(); d.getYear(); some times it reture 110, & some times 108 please help   Hi
store current system date in to database - Development process
store current system date in to database  Hi,this is my code . here iwant to store current system date in to database and want to store subdept..."].elements["combo2"].options.length=0; for (var i=0;i<% java.util.Date date
Operating System based Web Hosting
Operating System based Web Hosting On the basis of operating system, Web Hosting system has been differentiated on four categories: Windows based Web... Solaris OS based Web Hosting A. Windows Web Hosting Windows Web Hosting system
coding for updating profile
coding for updating profile  coding for updating profile
How to copy files from one folder to another based on lastmodified date - Java Beginners
Copy files from one folder to another  How to copy files from one folder to another based on lastmodified date
updating & deleting an employee
updating & deleting an employee  can anyone help out me please? advance thanks warm regards
Updating log4j programatically
Updating log4j programatically  Is there a ready made utility which I can use to edit the log4j.xml programmatically
date
date  i want difference between the date entered in a jtextfield and the system date in java
date
date  can u tell me how to calculate difference between a user provided date and the system date in java
date
date  can u tell me how to calculate difference between a user provided date and the system date in java
Updating using AngularJS
Updating using AngularJS  Shopping.html <!DOCTYPE HTML PUBLIC... one more button for updating items in the table for Updating Items in Shopping.html. On clicking updating button for each row ( as like Remove button in each
updating a table in a database - SQL
updating a table in a database  give me complete source code in java to execute the sqlquery such that (update table_name set phone no=? where cous_id=?). or in simple way give me source code to update my table in MsAccess
System
System  What is System in System.out.println() method? Is it a Class or a Package
php create pages automatically
php create pages automatically  How to create pages automatically in PHP
Updating user profile
Updating user profile  how should i provide user to update his profile with edit option including entered data by user should be shown in jsp page fileds   The given code retrieve data from database and display
sorting folders automatically
sorting folders automatically  i want to sort folders automatically,let say the folders to be displayed in a webpage(hyperlinked to its resource... be done automatically.whenever a folder is created it should automatically get
audio file to play automatically
audio file to play automatically  I want to get an audio file to play automatically when someone visits my site
Advertisements
 

 

 

DMCA.com