Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

total time including conversion

Status
Not open for further replies.
fireant

fireant

Technical User
Aug 12, 2001
28
0
0
PH
Hello,

I'd like to ask for your help, I'm not very good in SQL syntax.

I need to get the total time between field1 and field2 with format 10/14/2004 3:06:08 AM and post the result in format dd:hh:mm. Very much like how it is in Excel.

TIA!

Louie C.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
203
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
115
Andrzejek
Andrzejek
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
64
Chris Miller
Chris Miller
tn_sudheer
  • Locked
  • Question
Accessing data from database between given time stamps
Replies
11
Views
98
Andrzejek
Andrzejek
G12Consult
  • Locked
  • Question
Implicit conversion from data type error
Replies
14
Views
143
Olaf Doschke
Olaf Doschke

Part and Inventory Search

Sponsor

Back
Top