Multiple parameters in date comparison

[posiedon]

Hi

i have a series of user parameters that i would like to 'build' a date from for a comparison against a date field in a table.

the parameters are &dd, &mon, &yyyy, &hh24 and &mi.
how can i put them together in the format &dd:&mon:&yyyy:&hh24:&mi:00 in order to use them in a date comparison ie

select ....
from ....
where events.eventdate >= (TO_DATE('&dd:&mon:&yyyy:&hh24:&mi:00','DD:MON:YYYY:HH24:MI:SS'))

can i just put them together in the format above, or is there something else i have to do??

TIA

Stephen

 

[jee]

I assume you are dealing with SQL*PLUS user variables - in which case what you have should work.

If you are using bind variables or PL/SQL variables you have to build your string using the || concatonation operator.