Click here to Skip to main content
15,914,225 members

Comments by Member 15028582 (Top 62 by date)

Member 15028582 8-Mar-21 7:23am View    
How can we write.....easily ji...
Member 15028582 8-Mar-21 7:10am View    
Yes all columns are datetime only...give some example ji...Pls
Member 15028582 8-Mar-21 7:01am View    
Actually Ji....I have 4 columns....InTime,Outtime,stepintime,stepouttime....I need to first take the difference from (intime - outtime) as InoutTime after that I need to take the difference from (stepintime - stepouttime) as StepinTime and finally I need to subtract the (InoutTime - stepouttime) as Newcolumn result....So that first I Used to get the (intime - outtime) data and then (stepintime - stepouttime) data and the final step is pending pls help..
Member 15028582 8-Mar-21 6:42am View    
Actually ji....Just Imagine u have 2 columns...First column is INTime and Second column is OutTime....InTime=34:00:00 and OutTime=01:00:00...Both the columns are varchar(100) datatype....Now How can you minus the (InTime - outtime) as Finaltime column(new column) using sql query...Actually I have tried But the intime is greater than 24 hours so that it shows conversion failed error....
Member 15028582 3-Mar-21 22:41pm View    
DataRow[] rows = DTEvents.Select(
String.Format(
"FollowDate >= #{0}# AND FollowDate < #{1}#",
FromDate, ToDate // DateTime.Parse(e.Day.Date.ToShortDateString(), new System.Globalization.CultureInfo("pt-BR")).ToString("dd MMM yyyy"),
// DateTime.Parse(e.Day.Date.AddDays(1).ToShortDateString(), new System.Globalization.CultureInfo("pt-BR")).ToString("dd MMM yyyy")
)
);
This line got error