Extract and display time in Label from DateTime Field in ASP.Net

Question

My work is done properly all good with this query  1234SELECT name    CONVERT DATETIME DATEADDs SUM DATEPARThh Timer  3600        DATEPARTmi Timer  60   DATEPARTss Timer 0 AS totaltimeFROM ProjectToDone Groupbynamebut the result is shown like thisAli                    19000101 000005000 ddd                  19000101 002222000I want time like 002222 or 000005 How can i do this

Azim · Accepted Answer

If you want to show only time in Label then use it like this1ltaspLabel IDlblTime Textlt EvalTime 0hhmmss gt runatserver gtThank You

saifali · Answer

Thankyou i get my desired answer my answer is thisSELECT nameCONVERTtime0 DATEADDs SUM DATEPARThh Timer  3600    DATEPARTmi Timer  60  DATEPARTss Timer 0 AS Totaltime FROM ProjectToDone Group by name

Extract and display time in Label from DateTime Field in ASP.Net

Company

Explore

Follow us

Contact Us