Prob regarding Script

[nikhilgarg]

Hey,

I want to see the session length which is a column in session log file. I used following statement but it gives me no value under the column.

Num(Interval#(SessionDuration, 'hh:mm:ss')*24, '#,##0') as SessionLength

Also can anyone tell me what is this interval#() return if my Session Duration is : 13:21:45

Also why we need to multiply by 24?(Script is already created , not created by me so i have no idea why 24 is used)

Thanks

[Gysbert_Wassenaar]

I don't think multiplying by 24 is necessary as long as you understand that the value that the interval# function returns has days as unit. So 13:21:45 would become 0.556770833333, i.e. a bit more than half a day.

[nikhilgarg]

Ohk so you mean interval#() returns the duration in comparison with day i.e whether half day or more or less.

[Anonymous]

Hi Nikhil,

From Help:

Interval#

interval#(expression [ , format-code ])

The interval# function evaluates the expression as a time interval according to the string given as a format-code. If the format code is omitted, the time format set in the operating system is used.

The interval# function generally behaves just like the time# function but while times can never be greater than 23:59:59 (numeric value 0.99999) or smaller than 00:00:00 (numeric value 0.00000) an interval may have any value.

Examples:

The examples below assume the following operating system settings:

Short date format:	YY-MM-DD
Time format:	hh:mm:ss
Number decimal separator:	.

interval#( A, 'D hh:mm' ) where A=1 09:00 returns:

String	1 09:00
Number	1.375

interval#( A-B ) where A=97-08-06 09:00:00 and B=97-08-05 00:00:00 returns:

String	1.375
Number	1.375

Regards

Neetha

[nikhilgarg]

Hey,

Yeah i ahve gone thru that but was not clear about it initially. But now i am clear almost. it works in multiples of base, ryt?? And also does offset decreases the offset value from resultant value??

[jonathandienst]

Multiplying by 24 will convert the value to hours

[Gysbert_Wassenaar]

That I know. I just think that it's unnecessary.

[nikhilgarg]

Thanks dienst

[Anonymous]

Yes,it works in multiples of base,Multiplying by 24 will Show output in hours.

'And also does offset decreases the offset value from resultant value??' - there is no offset parameter in expression:

interval#(expression [ , format-code ])

Regards

Neetha

[nikhilgarg]

Yeh, Actually mistakenly i paste this in this section instead of Floor question post