| Author | Message | ||
Driverramudu Hero Username: Driverramudu Post Number: 14153 Registered: 02-2009 Posted From: 166.137.246.128 Rating: N/A |
Gagu Then what is ur expecting based on ur FP I gotta know given two dates finding diff in hours minutes and seconds Driving is my PASSION. Ball or Bimmer does not matter. | ||
Humpty_dumpty Moderator Username: Humpty_dumpty Post Number: 31271 Registered: 02-2009 Rating: N/A |
uthamudu ayina gopi letter | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 54776 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
LOL..but not 100% what I expected...but will play around with it | ||
Driverramudu Hero Username: Driverramudu Post Number: 14152 Registered: 02-2009 Posted From: 166.137.246.128 Rating: N/A |
Mental Miya Don't give hints to gagu Driving is my PASSION. Ball or Bimmer does not matter. | ||
Mental_sachinodu Hero Username: Mental_sachinodu Post Number: 17622 Registered: 10-2008 Posted From: 209.60.166.146 Rating: N/A |
answer fafer cofy kotte appudu peru kooda cofy kottevaadi la kanavaduthunnaaad kadha Guvvesh neeku  | ||
Driverramudu Hero Username: Driverramudu Post Number: 14151 Registered: 02-2009 Posted From: 166.137.8.64 Rating: N/A |
Gagu Note while creating that function change Database name to your database U might get exception as I used mine Driving is my PASSION. Ball or Bimmer does not matter. | ||
Driverramudu Hero Username: Driverramudu Post Number: 14150 Registered: 02-2009 Posted From: 166.137.8.64 Rating: N/A |
Gagu Chk ur mail Driving is my PASSION. Ball or Bimmer does not matter. | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 54775 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
just book marked it...chaala options already try chesaa...veella ki excel lo elaa vasthundhoo alaane kaavalanta...so trying other options | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 54774 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
rakesh.ccdb@gmail.com | ||
Driverramudu Hero Username: Driverramudu Post Number: 14149 Registered: 02-2009 Posted From: 166.137.8.64 Rating: N/A |
Gagu I got it your requirement For that u need to write custom function as I said  Gimme some time I would send function to you What is ur mail id Driving is my PASSION. Ball or Bimmer does not matter. | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 54773 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
how? | ||
Sooridu Junior Artist Username: Sooridu Post Number: 424 Registered: 10-2012 Posted From: 198.234.106.18 Rating: N/A |
annai ee link naaku eppudu bookmark lo untaadhi... emanna use aytaadeemo soodandi... http://www.sql-server-helper.com/tips/date-formats.aspx | ||
Maverick Legend Username: Maverick Post Number: 57990 Registered: 01-2008 Posted From: 108.171.130.188 Rating: N/A |
use select with case stmt Happy Vizag | ||
Driverramudu Hero Username: Driverramudu Post Number: 14147 Registered: 02-2009 Posted From: 166.137.8.64 Rating: N/A |
Gagu How no way We used extensively that we never had any issue Otherwise u might be using wrong way I.e later date first and earlier date next you should use Otherwise if the hours between two dates are beyond 23 then it will not work Then we need to create scalar function Driving is my PASSION. Ball or Bimmer does not matter. | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 54772 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
driver kaaka I tried that before....kaani BS results vasthunnay some extent work ayyindhi gaani more than 100 hours difference vunte first digit stripoff aipothaandhi... like difference 198:54 vundhi anuko...98:54 sooyisthondhi... Hours part lo 2 ni 3 chesthe...aaa 3 digit diff baane vundhi gaani 2 digit hours 013:25 avuthunnayi...malli less than 10 hour differece baane vundhi RIGHT('0' + convert(varchar(30), (datediff(mi, @startDate, @endDate) / 60)),3) | ||
Bharat Junior Artist Username: Bharat Post Number: 555 Registered: 06-2015 Posted From: 199.90.60.4 Rating: N/A |
This answer is better. | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 54771 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
Big data project ani theeskunnaru...vachaaka excel files ichi load cheyyamannaaru...chesthunnaa....naa gundem adindhi | ||
Driverramudu Hero Username: Driverramudu Post Number: 14143 Registered: 02-2009 Posted From: 166.137.8.64 Rating: N/A |
Concatenate with zeros and use right function to extract 2 characters Very silly one amma more over bettet one is u can use below function Select convert(varchar(10),@date2-@Date1,108) Driving is my PASSION. Ball or Bimmer does not matter. | ||
Bharat Junior Artist Username: Bharat Post Number: 554 Registered: 06-2015 Posted From: 199.90.60.4 Rating: N/A |
 | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 54769 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
SQL lo right ane function vundhaa...worked like a charm Thanks Bhayya...oka roju Modi ni thittanu | ||
Emc2 Legend Username: Emc2 Post Number: 44099 Registered: 03-2008 Posted From: 108.48.4.24 Rating: N/A |
date formattting ki $250/hr em company babu, naku kuda oka job chudu  | ||
Bharat Junior Artist Username: Bharat Post Number: 553 Registered: 06-2015 Posted From: 199.90.60.4 Rating: N/A |
select RIGHT('0' + convert(varchar(30), (datediff(mi, @startDate, @endDate) / 60)),2) + ':' + RIGHT('0' + convert(varchar(30), (datediff(mi, @startDate, @endDate) % 60)), 2) | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 54768 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
declare @startDate datetime declare @endDate datetime set @startDate = '2011-12-22 15:20:00.000' set @endDate = '2011-12-22 18:23:09.000' select convert(varchar(30), (datediff(mi, @startDate, @endDate) / 60)) + ':' + convert(varchar(30), (datediff(mi, @startDate, @endDate) % 60)) result 3:3 ani vasthaandhi....naaku 03:03 kaaavali....how? result |