More help with complex query

[dhaveedh]

Hi,

I have two time fields in a table as Start Time and End Time. They are both in the format 00:00:00.

I want to subtract the End Time from the Start time for each record in the table and return the value in minutes.

i.e Select StartTime - EndTime As Timevalue(in secs)

Can anyone help?

Much appreciated.

KISS - Keep It Simple Sugar!

 

[r937]

select datediff("n",StartTime,EndTime ) as minutes

rudy

http://r937.com/

SQL Consulting

 

[dhaveedh]

Muchos gracias

KISS - Keep It Simple Sugar!