How I can read a parameter with specified format

[vovidiu]

Hello,

How I can read a parameter date or number with specified format DD.MM.YYYY or 999g999g999g999d99.

Thnks,
Ovidiu

 

[Marco Kalter]

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:

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

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