No announcements
Found 2390800 threads
-
0 Voteshow 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 | ...Answered | 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
-
0 Votes
Calculating a date from datetime
I almost cried for help again :-))) ... until I found out SQL uses weirdest time notification I can think about.Answered | 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 -
1 Votes
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 ...Answered | 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 -
1 Votes
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 ...Answered | 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 -
0 Votes
DateTime Calculation
declare @t table ( Id int identity(1,1), FromTime datetime, ToTime datetime, TotalDuration ...Answered | 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 -
0 Votes
Help in Date calculation
Brad, That is true, but doesn't it depend on the undocumented DATETIME-is-a-FLOAT-internally thing?Answered | 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 -
0 Votes
datetime help
You can Unbox DateTime object to string with formatting specifier.Answered | 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 -
3 Votes
DateTime help
Hi, You can have different datetime format string from http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx ...Answered | 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 -
0 Votes
Help in DATEADD Calculation
Please check below code - create table #dates(date_start datetime,date_end datetime) declare @date_start datetime, @nb_period int, @nb_unit ...Answered | 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 -
1 Votes
Help in calculate date formula
Hope you can help to build query.Answered | 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 -
0 Votes
How to Calculation Datetime between every Record
[datetime],C1.Answered | 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 -
3 Votes
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.Answered | 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 -
0 Votes
Convert TextTime to DateTime in a calculated field
It helps others to find relevant posts to the same question.Answered | 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 -
2 Votes
Help in calculate the age as per condition
) Hope it Helps!!Answered | 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 -
0 Votes
Help with datetime
Hi everyone, I am scratching my head about a datediff function in a SQL ...Answered | 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 -
2 Votes
Datetime Please help
I would like to help you to move your case to the correct forum.Answered | 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 -
3 Votes
DateTime Question
Just in case you couldn't read BinaryCoder's embedded ...Answered | 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 -
0 Votes
DateTime Please Help
= 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 ...Answered | 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 -
1 Votes
Median Calculation on T-SQL need Help
', N'00G60000000vZAxEAM', 471) INSERT [LeadMedian] VALUES (11, N'Inactive', N'00Q6000000ZBKYvEAP', N'0016000000FwbyfAAB', CAST(0x00009F4E00000000 AS DateTime), 325, ...Answered | 5 Replies | 1732 Views | Created by Suneel R - Monday, July 29, 2013 4:19 AM | Last reply by Ch. Rajen Singh - Tuesday, July 30, 2013 6:13 AM -
0 Votes
Datetime Help - Query
Thank you guys it was a big help :DVHOAnswered | 4 Replies | 2371 Views | Created by emmim44 - Tuesday, September 11, 2012 10:45 AM | Last reply by emmim44 - Tuesday, September 11, 2012 2:47 PM - Items 1 to 20 of 2390800 Next ›
No announcements
