Hi All

Im trying to create a custom event which needs to use the Time portion of a DATE field, in this case to run a check against Holiday Request records.  When I put the event code in as follows, it only seems to bring through the Date itself with the Time always being set to 00.00.00.  This is despite the Debug Console showing that the time being put into the database is something else such as 11.30.00.

Has anyone had any success with the use of Date and Time in custom events?

My event code currently is 

DECLARE

   TIME_TO_         TIMESTAMP := TO_TIMESTAMP('&NEW:TIME_TO', 'YYYY-MM-DD-HH.MI.SS');
BEGIN
error_sys.Record_General('',TIME_TO_);

END;

The error shows that only the Date part is filled.  I have tried DATE instead of TIMESTAMP with the same result

Cheers

Gareth