No announcements
Found 2185081 threads
-
0 VotesTimes all return as 12:00:00 am
Hi folks. I've run into another one I can't seem to put my finger on. In my tables, there are columns that include times. However, the query is displaying those ...Answered | 2 Replies | 277 Views | Created by RobVanWinkle - Thursday, April 13, 2017 8:51 PM | Last reply by RobVanWinkle - Friday, April 14, 2017 2:00 PM
-
0 Votes
DateTime Parameter Adds 'AM 12:00:00'
in my report, as I said the user selects it from the DateTime parameter (calendar control) – and it automatically adds me hour "AM ...Answered | 7 Replies | 6989 Views | Created by Niron - Sunday, August 8, 2010 7:34 AM | Last reply by Niron - Monday, August 23, 2010 4:28 AM -
0 Votes
Return GETDATE() function as '12/23/2015 06:00:00'
> I would like to return the GETDATE() function as '12/23Answered | 8 Replies | 1648 Views | Created by GarinTiger - Wednesday, December 23, 2015 3:02 PM | Last reply by Sebastian I. Sajaroff - Wednesday, December 23, 2015 6:54 PM -
1 Votes
Calendar View to Hide 12:00 AM
We are trying some javascript via a content editor to hide the "12:00 AM" when viewing the data from a calendar view. It's only hiding the first ...Answered | 2 Replies | 1367 Views | Created by bubberz1 - Friday, February 20, 2015 4:47 PM | Last reply by bubberz1 - Friday, February 20, 2015 5:33 PM -
0 Votes
merged phone field displays 12:00:00 AM
number and vax number fields display correctly, but the cell phone number field displays 12:00:00 AM. All 3 phone number fields are identical. ...Answered | 9 Replies | 3881 Views | Created by Kalice - Wednesday, June 5, 2013 6:37 PM | Last reply by Kalice - Friday, June 7, 2013 4:15 PM -
0 Votes
dateTime parameter stop on 12:00 AM
Hi , A day in T-QSL starts at 31/1/2010 00:00:00.000 and ends at 31/1/2010 23:59:59.999 or to use the AM/PM syntax starts at ...Answered | 3 Replies | 4051 Views | Created by wael_e - Sunday, February 7, 2010 7:39 AM | Last reply by Jinchun Chen - Monday, February 8, 2010 7:48 AM -
0 Votes
Date Time Picker-Set time if left as default (12:00:00 AM)
I want to set the default time of a date/time picker if the user has not selected a time. In other words, if the time is 12:00:00 am, I want to change only ...Answered | 2 Replies | 4384 Views | Created by Nalani - Thursday, April 10, 2014 7:10 PM | Last reply by Nalani - Thursday, April 10, 2014 7:46 PM -
1 Votes
DATEVALUE() returning all dates with 12:00:00 AM instead of Time
I am concatenating two columns, Date and Time, and wrapping that in a DATEVALUE() func. All columns involved are recognized as Data Type: Date. My problem is ...Answered | 2 Replies | 783 Views | Created by IcyBricks - Thursday, March 17, 2016 4:42 PM | Last reply by IcyBricks - Friday, March 18, 2016 1:25 PM -
0 Votes
LastLogonDate 12/31/1600 7:00:00 PM
I am running a script to retrieve user parameters in an OU, including the log on date, and some are coming back as 12/31/1600 7:00:00 PM. Any idea ...Answered | 5 Replies | 7001 Views | Created by Milaism - Tuesday, October 17, 2017 4:13 PM | Last reply by Richard Mueller - Tuesday, October 17, 2017 9:57 PM -
0 Votes
Error ID 4199 TcpIp, IPv6 and MAC 00-00-00-00-00-00
IP address :: with the system having network hardware address 00-00-00-00-00-00. Network operations on this system may be disrupted as a ...Answered | 2 Replies | 6713 Views | Created by asc570 - Thursday, October 25, 2012 4:56 PM | Last reply by Aiden_Cao - Wednesday, October 31, 2012 1:58 AM -
0 Votes
How to show show MM/DD/YYYY 12:00:00 AM
We're missing here... Hmmm. Here's an example. I would want the data/time below to be reset to midnight. 1/23/2009 1:14:22 PM = 1/23/2009 ...Answered | 7 Replies | 6206 Views | Created by therandall - Friday, June 26, 2009 3:29 AM | Last reply by Sandeep Babbar - Monday, June 29, 2009 3:27 PM -
0 Votes
datetime field takes time as 00:00
SharePoint actually stores date/time in GMT zone. That is why it shows one day previous time. i.e. 00 means 12 AM of previous day. If you have checked ...Answered | 1 Replies | 809 Views | Created by exploreIT - Friday, August 14, 2015 11:19 AM | Last reply by Sachin_Jadhav - Thursday, September 3, 2015 11:57 AM -
0 Votes
Email from workflow contains "1/1/0001 12:00:00 AM" for item's empty date field
date field, it actually stored as "1/1/0001 12:00:00 AM". So youAnswered | 3 Replies | 9009 Views | Created by dgunnlds - Monday, October 1, 2012 11:01 PM | Last reply by CherryP - Tuesday, June 17, 2014 7:39 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 | 4493 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
Change time to 12:00 am
Hello. I would like to get rid of the time on dates in power query. How can I do that?Answered | 1 Replies | 280 Views | Created by AlexMartini - Monday, October 24, 2016 5:30 PM | Last reply by Colin Banfield - Monday, October 24, 2016 6:06 PM -
0 Votes
SSRS Date Format auto goinf to 12:00:00 PM
Thats the way datetime works in SQLServer. A time part of 00:00:00 means 12 midnight which is what is displayed as 12:00 ...Answered | 4 Replies | 3012 Views | Created by ProfessorFudger - Thursday, July 30, 2015 12:28 PM | Last reply by Shrek Li - Friday, July 31, 2015 3:00 AM -
0 Votes
How to change MAC address TO 00-00-00-00-00-00
install the latest version of its driver for Windows 7 to see how it works. " However, "00-00-00-00-00-00" is ...Answered | 1 Replies | 2812 Views | Created by Mehdi1373 - Thursday, December 3, 2015 10:57 AM | Last reply by Allen_WangJF - Friday, December 4, 2015 8:00 AM -
0 Votes
Format varchar string as 00:00
the values are different for rows like, 1:0 1:45 2:30 5:21 so i need ...Answered | 12 Replies | 532 Views | Created by sudhu99 - Thursday, August 16, 2018 4:46 AM | Last reply by Jingyang Li - Thursday, August 16, 2018 1:48 PM -
0 Votes
Why date field's default value is "1/1/0001 12:00:00 AM" + infopath 2013??
Hi All, I am facing an issue with Date field in the infopath, we are migrating data from lotus notes to SharePoint. Once data migrated, the ...Answered | 1 Replies | 2278 Views | Created by KumarSP2013 - Thursday, November 14, 2013 8:29 AM | Last reply by Sergio Giusti 79 - Thursday, November 14, 2013 10:16 AM -
1 Votes
Default date '1899-12-30 00:00:00.000'
THis date is not a key for the attribute. However I want to keep 1899-12-30 00:00:00.000' as it is and show only NULL as blank. Is there a way to achieve ...Answered | 7 Replies | 23587 Views | Created by AC_28 - Thursday, September 6, 2007 9:03 PM | Last reply by Amir5656 - Friday, January 7, 2011 9:08 PM - Items 1 to 20 of 2185081 Next ›
No announcements
