var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: time in millisecond
Is there any way in Oracle to display time in millisecond ?
This is a sort of good news bad news. In Oracle 9i and above, you can use the timestamp data element instead of date. Date only goes to seconds, timestamp goes to milliseconds.
Last edited by beilstwh; 08-30-04 at 15:16.
You do not need a parachute to skydive. You only need a parachute to skydive twice.
oracle displays differences in time in days...so, to do so in milliseconds (1000th of a second)....
divide by 24 (hours in a day)
divide by 60 (minutes in an hour)
divide by 60 (seconds in a minute)
divided by 1000 (milli seconds in a second)
select ((((((<later_time>) - <earlier_time>) / 24) / 60) / 60) / 1000) from <table>;
You can do it using java or C... Go here to find out how:
"The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
- Albert Einstein