DATE vs. TIMESTAMP in test window

[MikeM]

Hi,

I have a procedure that accepts a DATE and a TIMESTAMP and I test it in the test window, the DATE variable has the handy date select popup but the TIMESTAMP variable is a string.

This causes problems trying to get values into the TIMESTAMP variable.

I'm running 10g (10.1.0.4).

Is this a bug?

Thanks.

 

[Marco Kalter]

It is not a bug. Timestamps need to be entered/viewed in the NLS_TIMESTAMP_FORMAT or NLS_TIMESTAMP_TZ_FORMAT of the session.

 

[MikeM]

Thanks Marco, I was trying to use to_timestamp in the parameter input area, whereas simply 01/01/05 was all that is needed.