No announcements
Found 551597 threads
-
2 VotesGetDate() with timestamp 00:00:00
how can i get GetDate() with timestamp equal to 00:00:00 for ex, 2012-02-15 ...Answered | 4 Replies | 50847 Views | Created by UltraDev - Wednesday, February 15, 2012 1:27 PM | Last reply by RFEPetr - Wednesday, January 24, 2018 1:41 PM
-
0 Votes
Validation Exception: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.Answered | 10 Replies | 21355 Views | Created by MoneyR - Thursday, October 20, 2011 8:20 PM | Last reply by MoneyR - Friday, November 18, 2011 4:17 PM -
1 Votes
NIC appears to have MAC address of 00-00-00-00-00-00
quick inspection of my PC's network settings showed that the connected NIC had the MAC address of 00-00-00-00-00-00. At the time I put it down to ...Answered | 6 Replies | 51972 Views | Created by RichardCarr110 - Sunday, March 28, 2010 10:54 PM | Last reply by InTheZon3 - Thursday, April 19, 2018 2:09 PM -
0 Votes
meaning of SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. ???
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. What is the meaning of thisAnswered | 2 Replies | 13802 Views | Created by M.Kranthi Kumar - Sunday, September 15, 2013 1:18 AM | Last reply by Papy Normand - Sunday, September 15, 2013 7:19 AM -
0 Votes
Cannot view availability room using Room Finder for an hour (05:00 pm - 06:00 pm) even if it's set in working hours (08:00 am - 06:00 pm)
When using New Meeting request Room Finder doesn't show availability room for an hour (05:00 pm - 06:00 pm). The working hour in calendar options is set to ...Unanswered | 2 Replies | 4141 Views | Created by Bslashcg - Thursday, March 3, 2011 12:55 PM | Last reply by Bslashcg - Friday, March 11, 2011 3:43 PM -
0 Votes
How can I get Todays date as 7/24/2020 00:00:00
HI, How can I get Todays date as 7/24/2020 00:00:00 in Power queryAnswered | 1 Replies | 257 Views | Created by Sandip Ghosh59 - Friday, July 24, 2020 11:14 AM | Last reply by Herbert Seidenberg - Saturday, July 25, 2020 1:10 AM -
0 Votes
Is timebyday stored with 00:00:00 hours
When I query the MSP_EpmAssignmentByDay_UserView in ProjectServer_reporting database I am not able to see the hours only 00:00:00Answered | 1 Replies | 6318 Views | Created by GodzillaBorland - Monday, August 15, 2011 7:02 PM | Last reply by Wim Van Den Bergh [MCTS] - Friday, August 26, 2011 8:56 AM -
0 Votes
Passing DateTime to Powershell Results in 00:00:00 Time
"Received: $reftime" When I run Test1.ps1, I receive the messages in the console pane: Passing in: 06/17/2013 ...Answered | 4 Replies | 1126 Views | Created by mmore2 - Monday, June 17, 2013 5:53 AM | Last reply by mmore2 - Monday, June 17, 2013 2:56 PM -
0 Votes
Invalid column name '00:00'.
Hi polachan, You should use single quotation mark instead of double quotation marks --,Case When DateClockedIn is null Then "00:00" ...Proposed | 1 Replies | 456 Views | Created by polachan - Tuesday, March 12, 2019 9:42 AM | Last reply by Will_Kong - Tuesday, March 12, 2019 10:05 AM -
1 Votes
Calendar View to Hide 12:00 AM
; el[i].innerHTML = el[i].innerHTML.replace("12:00 AM",""); ...Answered | 2 Replies | 1362 Views | Created by bubberz1 - Friday, February 20, 2015 4:47 PM | Last reply by bubberz1 - Friday, February 20, 2015 5:33 PM -
0 Votes
How to make 00:00 hours to 24:00
though, would events that occur at 00:05 (12:05 AM) fall in the "24:00" bucket? And would that bucket get sorted to the ...Answered | 3 Replies | 3560 Views | Created by gandla chinnikrishna - Friday, February 8, 2013 4:24 AM | Last reply by Brent Greenwood - Monday, February 11, 2013 5:14 AM -
0 Votes
Drop Down menu w/ Time delete 00:00:00
00:00:00 at the end. This is obviously the default time. How can I remove this from within the Infopath drop down menu? I assume I could use some type of function? Also, it ... -
2 Votes
default to '0000-00-00 00:00:00.000' if null datetime
Set it on the client side when Date = '9999-12-31' THEN '0000-00-00'Answered | 5 Replies | 5120 Views | Created by LISA86 - Friday, October 14, 2016 5:25 PM | Last reply by --CELKO-- - Friday, October 14, 2016 6:49 PM -
0 Votes
CAst "21NOV1970:00:00:00" as [DT_DATE] with ssis
data types as flexible as possible. When you have all your data inside regular tables it's much easier to do the logic. For instance... converting ...Answered | 6 Replies | 4485 Views | Created by sql baby - Monday, October 19, 2009 5:16 AM | Last reply by Janus007 - Monday, October 19, 2009 6:38 PM -
0 Votes
00:00:00 Causing a big problem in import
I had another look at the data and it looks like it is formatted like 01DEC199900:00:00 and is consistent. If I split the date column into 2, one with 9 characters and one with ...Answered | 9 Replies | 773 Views | Created by GretaF - Wednesday, April 29, 2015 2:20 PM | Last reply by GretaF - Thursday, April 30, 2015 4:20 PM -
0 Votes
Length of Newly Recorded Shows is 00:00:00
Media Streaming with Windows 7 http://blogs.msdn.com/b/e7/archive/2009/05/12/mediaAnswered | 5 Replies | 1401 Views | Created by MrKQQL15 - Friday, November 15, 2013 9:44 PM | Last reply by MrKQQL15 - Saturday, November 23, 2013 11:05 PM -
0 Votes
Convert Varchar YYMM to YYYY-MM-DD 00:00:00
I figured it out...This is what I did using the table from the column w/in the table to convert the date from YYMM: 0608 to 2006-08-31 00:00Answered | 9 Replies | 11603 Views | Created by LZee - Thursday, October 9, 2008 4:39 PM | Last reply by Hunchback - Thursday, October 9, 2008 5:58 PM -
0 Votes
Packet received with invalid source MAC address (00:00:00:00:00:00)
Hi, We are getting the below error from Cisco and found a desktop generates this broadcast INVALIDSOURCEADDRESSPACKET: (Suppressed 33734 times)Packet received ...Answered | 1 Replies | 7315 Views | Created by boopathi subramaniam - Thursday, August 9, 2012 11:36 AM | Last reply by tracycai - Friday, August 10, 2012 6:01 AM -
0 Votes
MP Authoring Demo and Contest Live Meeting [Registration Details] June 3rd at 11:00 AM - 12:00 PM. Pacific
If you are interested in learning more about MP Authoring thru a live demo check out the following details. Register and check it out June 3rd at 11:00 AM - 12:00 ... -
0 Votes
DATETIME field - convert hours to 00:00:00
i have a datetime field within my table... that looks like this below. how do i remove the time field but have the time showing as 00:00:00.000? 2011-06-29 ...Answered | 2 Replies | 4883 Views | Created by Sam233 - Monday, July 4, 2011 9:27 AM | Last reply by swePeso - Monday, July 4, 2011 9:36 AM
No announcements
