Fractional Seconds on a Date data type.
I have been looking at what I think is an Oracle bug. But I thought that I would pose the question here before talking to support. My issue is represented in the code below. All the Oracle documentation I've looked at indicates that it should be possible to get fractional seconds from a date data type. But if you run the code below you get a constant value in the fractional seconds of the date data object.
declarev_timestamp timestamp(6);v_date date;x number := 0;beginwhile x < 10 loopx := x+1;v_date := sysdate;v_timestamp := systimestamp;