I need to retrieve milliseconds information from a date field.
I have used TO_CHAR and am able to retrieve the time till seconds (SS). but am not able to do so for msec.
Could you please give me the formate for msec if any. Or any other way of retrieving msec information.