Hello,
I have a procedure that writes record/s out to a table. I have a function that goes to try and determine what the last action was on the record. How it is determining this is doing a max(date). Well the procedure i first reference does it so quickly that the date that gets returned doing a max returns multiple results.
Do dates when they are written to what decimal place do they store seconds? Does it go down to the millisecond and if so, how do i convert my dates so that I am pulling the actual last record based on the date?
If i can't do this with a date is there a way to do this perhaps using the rownum do you think?
Thanks.