FUNCTION fDatediffSec

fDatediffSec(start,now) returns the difference in seconds as a float

parameters:
start datetime, -- start time
now datetime, -- end time
returns float -- elapsed time in seconds.
sample use: declare @start datetime set @start = current_timestamp do something print 'elapsed time was ' + str(dbo.fDatediffSec(@start, current_timestamp),10,3) + ' seconds'

Input and output parameters

name type length inout pnum

@start datetime 8 input 1

@now datetime 8 input 2

float 8 input 0

name	type	length	inout	pnum
@start	datetime	8	input	1
@now	datetime	8	input	2
	float	8	input	0