How to add Time in Coloumn and display the total time of that coloumn

Posted by saisuresh074-17816 under ASP.NET on 9/24/2012 | Points: 10 | Views : 1421 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi friends,
I have a coloumn in my table which contains time in format hh:mm:ss and now i want to add that whole coloumn time and display that ....i hav
written some query as follows for that

select convert(char(8),dateadd(second,SUM ( DATEPART(HH,(convert(datetime,working_hours,1))) * 3600 +
DATEPART(mi, (convert(datetime,working_hours,1))) * 60 + DATEPART(ss,(convert(datetime,working_hours,1)))),0),108) as t
FROM logindetails where date between @fromdate and @todate and user_id=@user_id and logout_time is not null

this is not adding if data has like 20:00:00..so plz help me out..

Attachment

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 9/29/2012 [Member] [MVP] Bronze | Points: 25

0	hi try this http://stackoverflow.com/questions/10830909/calculate-the-sum-of-the-column-which-has-time-datatype http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121027 http://www.sqlservercentral.com/Forums/Topic1271576-391-3.aspx#bm1275031 Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com saisuresh074-17816, if this helps please login to Mark As Answer. \| Alert Moderator

hi
try this


http://stackoverflow.com/questions/10830909/calculate-the-sum-of-the-column-which-has-time-datatype 

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121027 

http://www.sqlservercentral.com/Forums/Topic1271576-391-3.aspx#bm1275031

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

saisuresh074-17816, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 9/29/2012 [Member] [MVP] Bronze | Points: 25

0	hi Please mark as answer if it helpful to you. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com saisuresh074-17816, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts