No announcements
Found 1844170 threads
-
0 VotesSetting a DateTimePicker (Time) to 00:00:00
In 8% and some Coca Cola cultures that is English so the AM/AM is used in other situations the time is showed in a 24 hours clock (and in that 00:00:00 is showed ...Answered | 8 Replies | 18187 Views | Created by tropicwhisper - Thursday, October 4, 2012 1:04 PM | Last reply by Cor Ligthert - Saturday, October 6, 2012 2:57 PM
-
0 Votes
DateTimePicker Control Set time to 00:00:00 instead of current time
You could go to the designer and replace Time in Value property of the DateTimePicker control to 00:00.Answered | 1 Replies | 6081 Views | Created by Hrushi17 - Wednesday, May 12, 2010 7:04 AM | Last reply by Khanna Gaurav - Wednesday, May 12, 2010 7:19 AM -
0 Votes
Is timebyday stored with 00:00:00 hours
However this field is filled in with "dates" only... so no time indication!Answered | 1 Replies | 6678 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 -
2 Votes
default to '0000-00-00 00:00:00.000' if null datetime
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties ...Answered | 5 Replies | 8451 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 to make 00:00 hours to 24:00
I take it you're not up for the Time dimension route.Answered | 3 Replies | 3811 Views | Created by gandla chinnikrishna - Friday, February 8, 2013 4:24 AM | Last reply by Brent Greenwood - Monday, February 11, 2013 5:14 AM -
7 Votes
Trigger when Local time is 00:00
You can incorporate something like this: Dim tempDate As Date Dim tempMS As Integer tempDate = Now ' figure out total MS in a ...Answered | 7 Replies | 2368 Views | Created by VB_Newcomer_Kid - Saturday, July 14, 2012 8:31 AM | Last reply by Family Tree Mike - Saturday, July 14, 2012 4:13 PM -
0 Votes
CAst "21NOV1970:00:00:00" as [DT_DATE] with ssis
I could go on, but all my posts for the last 3-4 months in this SSIS-forum shows that T-SQL is superior in comparison to SSIS component-logic, not even one time has the ...Answered | 6 Replies | 4668 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
datetime field takes time as 00:00
SharePoint actually stores date/time in GMT zone.Answered | 1 Replies | 991 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
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?Answered | 2 Replies | 5066 Views | Created by Sam233 - Monday, July 4, 2011 9:27 AM | Last reply by swePeso - Monday, July 4, 2011 9:36 AM -
0 Votes
How to insert 24:00:00 into a datetime field?
Look at the half-open interval model CREATE TABLE TimeSlots (start_time TIME(2) NOT NULL, end_time ...Answered | 8 Replies | 12323 Views | Created by Phill_doh - Tuesday, June 21, 2011 1:14 PM | Last reply by --CELKO-- - Tuesday, June 21, 2011 4:06 PM -
2 Votes
Round off Time stamp in DateTime to 11:00 or 23:00
DECLARE Foobar DATETIME2(0); CASE WHEN CAST(foobar AS TIME) BETWEEN '05:00:00' AND ...Answered | 2 Replies | 871 Views | Created by czarvk - Monday, October 5, 2015 10:12 PM | Last reply by --CELKO-- - Tuesday, October 6, 2015 1:45 AM -
3 Votes
how to give timespan 24:00 instead of 00:00
I stored the time with 23:59:59 and used format for showing .Answered | 10 Replies | 16268 Views | Created by dhampall_79 - Thursday, September 20, 2012 7:46 AM | Last reply by Rick van den Bosch - Thursday, September 20, 2012 9:09 AM -
0 Votes
DateTime Parameter Adds 'AM 12:00:00'
I don’t display the date in my report, as I said the user selects it from the DateTime parameter (calendar control) – and it automatically adds me ...Answered | 7 Replies | 7245 Views | Created by Niron - Sunday, August 8, 2010 7:34 AM | Last reply by Niron - Monday, August 23, 2010 4:28 AM -
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 | 890 Views | Created by IcyBricks - Thursday, March 17, 2016 4:42 PM | Last reply by IcyBricks - Friday, March 18, 2016 1:25 PM -
0 Votes
How to convert 11:00 to time
declare @time1 char (5), @time2 char (5) select @time1 = '11:00', @time2 = '11:22' select RIGHT( '00' + ...Answered | 4 Replies | 3594 Views | Created by hi123456 - Friday, October 8, 2010 3:50 AM | Last reply by Alexey Knyazev - Friday, October 8, 2010 4:46 AM -
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 | 3987 Views | Created by ProfessorFudger - Thursday, July 30, 2015 12:28 PM | Last reply by 王者荣耀 - Friday, July 31, 2015 3:00 AM -
4 Votes
Converting Varchar column 07MAR2012:00:00:00.000 into datetime in SQL
., first make it look like: 07 MAR 2012 :00:00:00.000.Answered | 4 Replies | 911 Views | Created by AussieFH - Sunday, June 14, 2015 1:22 PM | Last reply by AussieFH - Sunday, June 14, 2015 11:42 PM -
7 Votes
I have a program that it has a label that indicate a time, on it!
I have a program that it has a label that indicate a time, on it!Answered | 7 Replies | 541 Views | Created by rari.paunescu - Wednesday, January 28, 2015 9:08 PM | Last reply by Reed Kimble - Thursday, January 29, 2015 5:34 AM -
3 Votes
Set time based on Getdate() to 00:00
The easiest way, in general, (assuming you are on SQL 2008 or later) to strip the time from any datetime is to cast it as a date, so set ...Answered | 4 Replies | 4574 Views | Created by My-Shi - Tuesday, September 13, 2011 3:35 PM | Last reply by My-Shi - Tuesday, September 13, 2011 3:57 PM -
2 Votes
How to get yesterday's date set to 00:00 hrs
You can use DateTime.Today.AddDays(-1) Now uses the current Date and Time.Answered | 11 Replies | 3776 Views | Created by Xaria - Wednesday, June 23, 2010 8:37 AM | Last reply by Jesse Houwing - Friday, June 25, 2010 12:36 PM - Items 1 to 20 of 1844170 Next ›
No announcements
