Hi
When i run a query in sqlplus with set timing on
i get
Table created.
Elapsed: 00:28:1696.52
how do i interpret this ? is it approx 30 minutes or 28 minutes ?
what does the value 1696 represet in the seconds column
regards
Hrishy
Printable View
Hi
When i run a query in sqlplus with set timing on
i get
Table created.
Elapsed: 00:28:1696.52
how do i interpret this ? is it approx 30 minutes or 28 minutes ?
what does the value 1696 represet in the seconds column
regards
Hrishy
1696/60 = 28.2666 = 28min 16sec.
Your SQL*Plus version probably doesn't match the server version.
HH:MM:SS.SS is the formatQuote:
Originally Posted by hrishy
then what's 1692.52? :confused:
Already the result has 28 as mins then 1696/60 once again gives 28.2666, are you sure they are minuteQuote:
1696/60 = 28.2666 = 28min 16sec
Looks like your nls setting may be using the ss.ff format.
FF [1..9]
Fractional seconds; no radix character is printed (use the X format element to add the radix character). Use the numbers 1 to 9 after FF to specify the number of digits in the fractional second portion of the datetime value returned. If you do not specify a digit, then Oracle uses the precision specified for the datetime datatype or the datatype's default precision.
Examples: 'HH:MI:SS.FF'
http://download-west.oracle.com/docs...ts4a.htm#48515
Gotcha!Quote:
Originally Posted by dbtoo
the format set as 'hh:mi.ff4:ss' could get you the above "00:28:1696.52" where 28.1696 is the mins. is that right!!!!!!
Good work dbtoo!
Hi Guys
Thanks a bunch for that explanation
regards
Hrishy