Posted by Roy Harvey (MVP) on 09/19/07 03:39

On Tue, 18 Sep 2007 19:28:20 -0700, "brazil.mg.marcus.vinicius.lima"
<marcvlima@gmail.com> wrote:

>When I perform a datetime subtraction (get the diference between two
>dates) can i convert the results to seconds?
>Thanks a lot!

The DATEDIFF function's first parameter specifies if the difference is
calculated in seconds, minutes, hours, weeks, years, etc.

Roy Harvey
Beacon Falls, CT

• Next in forum: Using ASP.NET to login to SQL Server 2005 Database
• Prev in forum: Re: How to work with time in format 'hhh:mm:ss' (more than 24 hours)
• Thread view: Re: How to work with time in format 'hhh:mm:ss' (more than 24 hours)

[Reply to this message]