No announcements
Found 2570248 threads
-
0 VotesDateTime Parameter Adds 'AM 12:00:00'
I do not think it is possible to format a DateTime parameter value in the parameter itself.....Answered | 7 Replies | 7457 Views | Created by Niron - Sunday, August 8, 2010 7:34 AM | Last reply by Niron - Monday, August 23, 2010 4:28 AM
-
0 Votes
Gridview showing Date value as DateTime 2/2/2020 12:00:00AM
User475983607 posted rogersbr this is about the gridview showing the date and ...Unanswered | 19 Replies | 2520 Views | Created by Anonymous - Sunday, February 2, 2020 8:41 AM | Last reply by Anonymous - Tuesday, February 4, 2020 12:02 PM -
1 Votes
Default date '1899-12-30 00:00:00.000'
However I want to keep 1899-12-30 00:00:00.000' as it is and show only NULL as blank.Answered | 7 Replies | 26721 Views | Created by AC_28 - Thursday, September 6, 2007 9:03 PM | Last reply by Amir5656 - Friday, January 7, 2011 9:08 PM -
0 Votes
Calculating a date from datetime
12:00AM 12:59AM 1:00 AM 2:00 AM ...Answered | 5 Replies | 3914 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
DATEVALUE() returning all dates with 12:00:00 AM instead of Time
That's the way DATEVALUE Function (DAX) works; it returns the date value, same as TIMEVALUE Function (DAX) returns only the time value.Answered | 2 Replies | 993 Views | Created by IcyBricks - Thursday, March 17, 2016 4:42 PM | Last reply by IcyBricks - Friday, March 18, 2016 1:25 PM -
0 Votes
SSRS Date Format auto goinf to 12:00:00 PM
Hi, According to your description, you want to format the time part in date to “12:00:00 PM”, right?Answered | 4 Replies | 4475 Views | Created by ProfessorFudger - Thursday, July 30, 2015 12:28 PM | Last reply by 王者荣耀 - Friday, July 31, 2015 3:00 AM -
0 Votes
How to convert a column of "Apr 14 2004 12:00AM" nvarchar format to "14-Apr-2004" nvarchar format in a table?
ID hdcasename ----------- ---------------------------------------------------------------------------------- 4 Apr 14 2004 12:00AM 5 Apr 15 ...Answered | 11 Replies | 6362 Views | Created by LadyCarol - Tuesday, November 2, 2010 9:56 AM | Last reply by Kalman Toth - Tuesday, November 2, 2010 11:28 AM -
0 Votes
Syncing row containing datetime column with date value 1753-01-01 00:00:00.000 on device
Date in sql server: 2010-02-01 00:00:00.000 Regional setting English Timezone -8 1/31/2010 ...Answered | 23 Replies | 11898 Views | Created by Oled - Monday, March 1, 2010 12:06 PM | Last reply by JuneT - Wednesday, March 24, 2010 8:51 PM -
2 Votes
Howto format string "2/16/2005 12:00:00 AM" to DateTime
-or-12-p.m.Answered | 4 Replies | 3835 Views | Created by Anders Fredborg - Monday, May 9, 2011 9:49 AM | Last reply by Anders Fredborg - Monday, May 9, 2011 12:23 PM -
2 Votes
default to '0000-00-00 00:00:00.000' if null datetime
You can use coalesce to replace the null, with the current date or whatever default value you want to use (like the creation date of your company).Answered | 5 Replies | 9897 Views | Created by LISA86 - Friday, October 14, 2016 5:25 PM | Last reply by --CELKO-- - Friday, October 14, 2016 6:49 PM -
0 Votes
How do I query a column in which it's datetime format is yyyy-mm-dd hh:mm:ss:mmm e.g. '2010-12-11 12:00:00.000' using Where = '12/11/2010 12:00:00 AM'
try this one: Select * from WSCAN2010 WHERE matnum ='C4918' AND ordRefno = 'CSO-10000002' AND convert(varchar(20),delDate ,101)= ...Answered | 10 Replies | 5460 Views | Created by Jason Alerta Obina - Friday, December 17, 2010 9:50 AM | Last reply by Jason Alerta Obina - Monday, December 20, 2010 2:50 AM -
2 Votes
Work Item's "Revised Date" column value defaults to 1/1/9999 12:00:00 AM in the Team Queries
Hi, If you are looking for the date/time the workitem was changed, use the System.ChangedDate field instead.Answered | 1 Replies | 7175 Views | Created by theyc123 - Monday, June 1, 2009 5:50 PM | Last reply by Mareen P - Monday, June 1, 2009 6:36 PM -
1 Votes
change the time of a datetime value
I have 2 datetime values: StartDate ('11/01/2010 00:00:00') and NewStartTime ('12/02/2010 09:30:00AM') I want to ...Answered | 1 Replies | 3229 Views | Created by ssfftt - Wednesday, February 3, 2010 7:38 AM | Last reply by Louis.fr - Wednesday, February 3, 2010 8:10 AM -
0 Votes
How to change the default time of date time picker from 12:00AM in wpf
Bind the DatePicker to Dated, the TimePicker to JustTime and you get the two together in FullDateTime: private DateTime ...Answered | 11 Replies | 7367 Views | Created by Katlogeous - Monday, July 21, 2014 12:23 PM | Last reply by Andy ONeill - Tuesday, July 22, 2014 8:29 AM -
0 Votes
DATETIME field - convert hours to 00:00:00
SELECT DATEADD(DAY, DATEDIFF(DAY, '19000101', Col1), '19000101') FROM dbo.Table1 N 56°04'39.26" E 12°55'05.63"Answered | 2 Replies | 5248 Views | Created by Sam233 - Monday, July 4, 2011 9:27 AM | Last reply by swePeso - Monday, July 4, 2011 9:36 AM -
2 Votes
Combining 2 DateTime into a single DateTIme variable
Keeping in mind date may have some time //value and time may have date value.Answered | 7 Replies | 2274 Views | Created by ss1w - Tuesday, October 1, 2013 3:12 AM | Last reply by Wasabi Fan - Tuesday, October 1, 2013 3:54 AM -
0 Votes
convert(datetime,'1600-12-31 04:00:00',120) sql server throws out of range
I think it's because of date range of the datetime datatype.Answered | 4 Replies | 4640 Views | Created by Siva Kumar Balaguru - Friday, March 29, 2013 4:16 PM | Last reply by --CELKO-- - Friday, March 29, 2013 5:01 PM -
1 Votes
.NET: what is different between Date and DateTime?
How do we know that if "2:00AM" we need assume is tomorrow in the code?Answered | 22 Replies | 17582 Views | Created by JJChen - Friday, May 10, 2013 12:02 AM | Last reply by Cor Ligthert - Friday, May 31, 2013 6:44 AM -
0 Votes
How to insert 24:00:00 into a datetime field?
Some SQL products will allow 24:00:00 as input and then correct it when the value is displayed.Answered | 8 Replies | 13110 Views | Created by Phill_doh - Tuesday, June 21, 2011 1:14 PM | Last reply by --CELKO-- - Tuesday, June 21, 2011 4:06 PM -
1 Votes
Query in SQL Server 2005 Where in 2 column
= '01/30/2014 15:00:00' AND cast((left(datecommitted,12)+' '+right(timecommitted,7)) as datetime)Answered | 9 Replies | 1316 Views | Created by Deo Gracias M. Cabral - Monday, February 10, 2014 8:10 AM | Last reply by Sarat (SS) - Tuesday, February 11, 2014 6:42 AM - Items 1 to 20 of 2570248 Next ›
No announcements
