PL/SQL (MOSC)

MOSC Banner

Fractional Seconds on a Date data type.

edited Apr 23, 2013 3:15AM in PL/SQL (MOSC) 6 commentsAnswered
 Hi Guys,

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center