5
Answers

About switching company

Nikhil Shende

Nikhil Shende

9y
608
1
Hi, i am currently working as a .Net Developer in a company.when i joined this company all the projects were completed and they want me to work for the Maintenance of these projects.I am not getting a single Development work. I have completed five months in this company..what i should do now????
Answers (5)
0
Kunal Vaishya

Kunal Vaishya

NA 4.1k 266.1k 12y
Dear try this


Select UserCode,
Cast((DateDiff(mi,Starttime,EndTime) / 60) As Varchar(8)) + ':' +
Cast((DateDiff(mi,Starttime,EndTime) % 60) As Varchar(2)),Starttime As [In Time],EndTime  As [Out Time ]From tblLogIn




Accepted
0
Senthilkumar

Senthilkumar

NA 15.2k 2.4m 12y
Hi,

Note that when you use the HH will give the date difference in hours. But it needs something like entire different between two dates.

I think get the seconds or minutes and find the differences, so you can calculate the actual time different by diving the minutes.


0
Gohil Jayendrasinh

Gohil Jayendrasinh

NA 5k 2.8m 12y
Hi
use datediff like

select


sum(Datediff(hour,StartingDate,EndingDate)) from ItemDiscount