I have a
java application that schedule some jobs, the user have a graphic interface when they can put the numbers of days, the number of hours or the number of minutes. when they want the job to be executed. Example: a user can select i want my job to be executed every 4 days and 2 hours and 30 minutes.
I have 3 columns in a table where i would store this values like this
;
I'm not sure about how to do this, is there a way to only insert days using the date datatype, or only save the hours, or only save the minutes.
How should i do this?
I use interval day(100) to second(0) but i don't know what this means i taked that from some web site but i don't know how that work. Any suggestion would be apreciated even if i you suggest using other data types