No announcements

### how to convert string to datetime & Calculate the Datetime

http://msdn.microsoft.com/en-us/library/s2dy91zy%28v=VS.100%29.aspx   Kee Poppy [MSFT] MSDN Community Support | ...
| 3 Replies | 3427 Views | Created by djrishen - Wednesday, March 23, 2011 9:28 AM | Last reply by Kee Poppy - Monday, March 28, 2011 9:11 AM

### Calculating a date from datetime

I almost cried for help again :-))) ... until I found out SQL uses weirdest time notification I can think about.
| 5 Replies | 3719 Views | Created by ArviL - Thursday, July 9, 2009 8:37 AM | Last reply by K H Tan - Thursday, July 9, 2009 1:42 PM

### Using DateTime to calculate time between two dates

Have a nice day, Jackie Sun [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from ...
| 6 Replies | 16306 Views | Created by kenpopaul - Thursday, August 11, 2011 8:06 AM | Last reply by kenpopaul - Monday, August 15, 2011 11:21 AM

### Calculating hours from DateTime

You need to get the hours from the DateTime value for 12 and the minutes from the DateTime value (i.e. 30) and divide 100 by 60 which is 1.6666666666666666666666666666667 and ...
| 3 Replies | 524 Views | Created by Y a h y a - Saturday, November 7, 2015 12:47 AM | Last reply by Mr. Monkeyboy - Saturday, November 7, 2015 1:56 AM

### DateTime Calculation

declare @t table ( Id int identity(1,1), FromTime datetime, ToTime datetime, TotalDuration ...
| 2 Replies | 4149 Views | Created by R L W - Thursday, January 28, 2010 1:48 PM | Last reply by ramireddy - Thursday, January 28, 2010 2:00 PM

### Help in Date calculation

Brad, That is true, but doesn't it depend on the undocumented DATETIME-is-a-FLOAT-internally thing?
| 8 Replies | 4276 Views | Created by Khan_K - Thursday, May 14, 2009 1:46 PM | Last reply by Paul White (NZ) - Friday, May 15, 2009 2:19 AM

### datetime help

You can Unbox DateTime object to string with formatting specifier.
| 3 Replies | 2169 Views | Created by It_s Meee - Wednesday, August 4, 2010 7:08 AM | Last reply by Mike_999 - Wednesday, August 4, 2010 7:20 AM

### DateTime help

Hi, You can have different datetime format string from http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx ...
| 5 Replies | 2360 Views | Created by It_s Meee - Wednesday, June 3, 2009 4:20 AM | Last reply by AnupDG - Wednesday, June 3, 2009 7:46 AM

Please check below code - create table #dates(date_start datetime,date_end datetime) declare @date_start datetime, @nb_period int, @nb_unit ...
| 4 Replies | 1031 Views | Created by rahulme81 - Monday, July 22, 2013 10:30 AM | Last reply by Harish83 - Monday, July 22, 2013 12:30 PM

### Help in calculate date formula

Hope you can help to build query.
| 6 Replies | 4382 Views | Created by Aaban_M - Friday, May 22, 2009 6:30 AM | Last reply by Aaban_M - Friday, May 22, 2009 3:27 PM

### How to Calculation Datetime between every Record

[datetime],C1.
| 12 Replies | 3444 Views | Created by Hitesh1508 - Monday, September 5, 2011 8:59 AM | Last reply by Badii Gharbi - Monday, September 5, 2011 12:40 PM

### SLA Calculation Help needed in Excluding Weekends and Off business hours for calculation

The section where you calculate holiday has a OR condition first i.e.
| 19 Replies | 10578 Views | Created by Manjunath C Bhat - Wednesday, May 8, 2013 10:16 AM | Last reply by S Ansari - Thursday, August 3, 2017 8:21 PM

### Convert TextTime to DateTime in a calculated field

It helps others to find relevant posts to the same question.
| 18 Replies | 665 Views | Created by ProfessorFudger - Friday, January 29, 2016 9:18 AM | Last reply by Patrick Hurst - Friday, January 29, 2016 2:33 PM

### Help in calculate the age as per condition

) Hope it Helps!!
| 8 Replies | 751 Views | Created by Khan_K - Tuesday, May 17, 2016 8:11 PM | Last reply by Stan210 - Wednesday, May 18, 2016 12:31 PM

### Help with datetime

Hi everyone, I am scratching my head about a datediff function in a SQL ...
| 3 Replies | 451 Views | Created by anahimself - Thursday, December 24, 2015 11:05 AM | Last reply by Erland Sommarskog - Thursday, December 24, 2015 1:02 PM

| 3 Replies | 4984 Views | Created by mindonmoney100 - Monday, May 14, 2012 8:43 AM | Last reply by Luigi Bruno - Monday, May 28, 2012 8:49 PM

### DateTime Question

Just in case you couldn't read BinaryCoder's embedded ...
| 3 Replies | 2386 Views | Created by jafTwo - Monday, January 12, 2009 11:39 PM | Last reply by jafTwo - Wednesday, January 14, 2009 2:03 AM

= new DateTime(int.Parse(year),int.Parse(month),int.Parse(day),int.Parse(hours),int.Parse(minutes),int.Parse(seconds)) you may pass 0 for seconds if you don't have ...
| 3 Replies | 1774 Views | Created by mindonmoney100 - Monday, May 14, 2012 8:48 AM | Last reply by Mudasir.Khan - Tuesday, May 15, 2012 9:39 AM