Share on Google+Share on Google+

Neo Java Developer
updating column automatically based on system date
1 Answer(s)      6 years and 6 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.

Ads

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
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
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
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
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
date
date  can u tell me how to calculate difference between a user provided date and the system date in java
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
php create pages automatically
php create pages automatically  How to create pages automatically in PHP
System
System  What is System in System.out.println() method? Is it a Class or a Package
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
Tutorials   
Java Spring Hibernate Struts Training Retrieve database from the table dynamically in jsp from oracle using servlet What does core Java include? java What are some way to learn Java quickly? Is it required to learn Java before learning Java Script? Is it necessary to learn java script before learning PHP? Are HTML5 and Java Script boosts Java career? Is Java object oriented? Fingerprint application with Java Uninstall Oracle Virtual Box JSON to HashMap Free Java online Training I want example of Control Statement in Java ANSI Color Codes with Python Create a Program that Calculates Input What is difference between JDK,JRE and JVM? How to see ubuntu version on server? How to get Page Source in Selenium (WebDriver) using Java? The path to the driver executable must be set by the webdriver.gecko.driver system property parse data from a link in java Java Program Qns using BlueJ How to fix HAX Kernel Module Is Not Installed error? Installing Audacity Looking for code Logic to check track changes & Coments in MSWord, MSWordx, MSExcel, MSExcelx is ON/OFF Installing JDK on Mac SAX Parser exception ERROR 601 (42P00): Syntax error. Encountered Thread java.lang.NoClassDefFoundError: org/apache/commons/fileupload/FileItemFactory How to install Ubuntu 16.04 LTS? HttpServletRequest cannot be resolved to a type in eclipse - Solved Unhandled event loop exception GC overhead limit exceeded Spring Data jpa with apache phoenix Caused by: java.lang.IllegalArgumentException: Not a host:port pair: PBUF o.a.h.h.z.RecoverableZooKeeper - Possibly transient ZooKeeper, quorum= com.thinkaurelius.titan.diskstorage.hbase.HBaseStoreManager class not found com.thinkaurelius.titan.diskstorage.hbase.HBaseStoreManager not found How to download and install Java 8 on Windows? How to uninstall JDK 7? How to install gtk-doc-tools package in Ubuntu? How to install Oracle JDK 8 on Ubuntu? ejabberd_ctl.beam not found - Solved How to convert date to UTC format in Java? How to install autoconf, automake and libtool in Ubuntu 15.10? How to convert current date to mm dd yyyy format in Java? How to convert current date to dd mm yyyy format in Java? How to stop window closing in "internalFrameClosing" event. How to find list of all index in Neo4j? neo4j-server.properties file location SASLError using PLAIN: not-authorized

Ads

 
Advertisement null

Ads