I am writing a default scheduler for my project and it needs to be triggered 7 days later the deployment of project. Can somebody help me writing an INSERT statement which takes (CURRENT_DATE + 7 days) as a value for DATE field.
INSERT INTO PURGE_ACC (START_DATE, REPEAT_INTERVAL) VALUES ( *(CURRENT_DATE + 7 DAYS)*, 604800000); REPEAT_INTERVAL is of long type and value associated with it is 7 days. I am having issue in settting [START_DATE+7 days] value. -- Thanks, Manoj -- View this message in context: http://apache-database.10148.n7.nabble.com/How-to-INSERT-CURRENT-DATE-7-DAYS-in-apache-derby-tp129786.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
