convert time durations 1

[Delphin]

I need to develop a stored procedure or view that will convert the time duration of several calls to seconds.

Here is what i am recieving:

Duration
00:02:30
00:10:01
00:03:29

I need to convert these to total number of seconds per call in the view so I can add these up in a SP or in crystal for a daily and MTD report on agent activity

Duration
150
6001
209

Billy Ballard

For in the past, Lies the future.

 

[dbomrrsm]

select cast(substring('00:02:30',1,2) as int)*3600+
cast(substring('00:02:30',4,2) as int)*60+
cast(substring('00:02:30',7,2) as int)

[blue]DBomrrsm[/blue]

 

[donutman]

   [Blue]SELECT[/Blue] [Fuchsia]DateDiff[/Fuchsia][Gray]([/Gray]ss[Gray],[/Gray]0[Gray],[/Gray][red]'00:02:30'[/red][Gray])[/Gray]

-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[dbomrrsm]

a bit neater than mine !

[blue]DBomrrsm[/blue]

 

[vongrunt]

... and a bit faster than me

 

[Delphin]

beautiful. TY

Billy Ballard

For in the past, Lies the future.

 

[donutman]

I'd say even a byte, except that I'd break my arm patting myself on the back.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]