db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From manojkumar16 <manojkuma...@gmail.com>
Subject How to INSERT (CURRENT_DATE+7 DAYS) in apache derby
Date Mon, 29 Apr 2013 06:50:52 GMT
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.

Mime
View raw message