java - How can we give the value dynamically in VIEW of sql -

i created on view in want dynamic value entered user in front end

 round((sysdate - io.movementdate), 2) totaldays, 

in above line taking sysdate want date entered user

a value cannot have input.
should create stored procedure returns query result, view. in stored can provide input parameters.

for example (assuming db vendor sqlserver):

create procedure [dbo].[testprocedure] @param int exec caller select * yourtable id = @param; go 

and can call with:

exec testprocedure 34; 

where 34 value want pass.