How I can read a parameter with specified format

You cannot specify the date or number format of a substitution variable. A date ot number must conform to the current Windows format.

You can however convert from a specific format in your query. For example:[quote]

Code

select * from emp
where hiredate > to_date(&<name="Hiredate" type="string">, 'dd.mm.yyyy')

[/quote]

------------------
Marco Kalter
Allround Automations