|
|
Posted by Martijn Tonies on 09/30/59 11:45
> I am creating a report that has call duration and if i run it over a
> multi-day span the duration is limited to 24 hours and starts over at
> zero. is there a way to not limit hours?
>
> I am usign the following in my select statement:
>
> convert(varchar(12), dateadd(s,
> SUM(ISNULL(Calls.OutgoingCallDuration,0)), '19900101'), 108) AS
> [Outgoing Call Duration]
There _is_ no time over 24 hours.
Think of the problem differently: you're trying to put a _duration_ into
a place that only allows _time_ values. That's not going to fit. Well,
yeah, it fits if the duration is below the length of 24 hours, but that's
it.
Now, given that, a "duration" could never be the same as a "time"
(eg: 01:23 PM).
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
Navigation:
[Reply to this message]
|