Hi AllIm 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');BEGINerror_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 resultCheersGareth
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.