Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aziz
Starting Member
1 Post |
 Posted - 2010-11-13 : 00:37:27
|
| I have recorded data as Staff_Number|Tr_Date|Tr_Time_IN|Tr_Time_OUT1000|20101112|170700|210930I want to display the data as followsStaff_Number|Tr_Date|Tr_Time_IN|Tr_Time_OUT|Total_working_hours1000|2010-11-12|05:07:00 PM|09:09:30 PM|04:02How to do it by querie |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-11-15 : 04:56:38
|
| What is the logic you have used to find the time?MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
How to display time