Number of seconds Between 2 Dates

Hi,
Can anyone tell me a way of calculating the number of seconds that have
elapsed between 2 date time fields e.g. I would to know the total number of
seconds
between GetDate() and GetDate() - 1
Thanks,
David.Use datediff function.
SELECT Datediff(ss,firstdate, seconddate) as elapsedSec
"David Lee" <dleeid@.internode.on.net> wrote in message
news:123p5tnn2r9b52d@.corp.supernews.com...
> Hi,
> Can anyone tell me a way of calculating the number of seconds that have
> elapsed between 2 date time fields e.g. I would to know the total number
of
> seconds
> between GetDate() and GetDate() - 1
> Thanks,
> David.
>|||Make use of DateDiff function.
Select dateDiff(ss, <<startDate>>, <<EndDate>> )
Best Regards
Vadivel
http://vadivel.blogspot.com
"David Lee" wrote:

> Hi,
> Can anyone tell me a way of calculating the number of seconds that have
> elapsed between 2 date time fields e.g. I would to know the total number o
f
> seconds
> between GetDate() and GetDate() - 1
> Thanks,
> David.
>
>