get time difference

Hi,

may be it ll help you and l give you some ideas to get the desired result:

http://stackoverflow.com/questions/2821040/how-do-i-find-the-time-difference-between-two-datetime-objects-in-asp-net

if not then please let me know.

Thanks.

0

sathish kumar13y ago

DateTime startDate= convert.Todatetime(txtbox1.text).tostring();

DateTime EndDate= convert.Todatetime(txtbox2.text).tostring();

   TimeSpan ts;

   ts= startDate- EndDate

     int s = ts.Todays();

     Hope this will help u out......

0

Shankar M14y ago

Yes, You can use the cast to convert it to DATE type.

Hope the below link might help you.
http://sqlusa.com/bestpractices2005/sqlserverstringtodate/

Thanks,
Shankar

0

Muhammad younas14y ago

can i change type in query to get difference. like casting

0

Shankar M14y ago

Hi User,

Convert the varchar datatype to date and try comparing using the DATEDIFF function.

Something like this,

select datediff(d,getdate(),getdate()); will get you the Difference in days.

Thanks,
Shankar

0