dbTalk Databases Forums  

SQL Report

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools SQL Report

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL Report in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Olutimi
 
Posts: n/a

Default SQL Report - 08-22-2003 , 08:40 AM





Please HELP.

How do you compute time differnce in hours and minutes
between two dates. I run SQL SErver 2K,SP3 on WIN 2k SP3
CLUSTERED.


Regards


Olutimi

Reply With Quote
  #2  
Old   
Brian Moran
 
Posts: n/a

Default Re: SQL Report - 08-22-2003 , 08:54 AM





Take a look at the datediff, datepart, and other date related functions in
BooksOnline. You should be able to piece together what you need.

--

Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com


"Olutimi" <olutimi (AT) hotmail (DOT) com> wrote

Quote:
Please HELP.

How do you compute time differnce in hours and minutes
between two dates. I run SQL SErver 2K,SP3 on WIN 2k SP3
CLUSTERED.


Regards


Olutimi



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top