No announcements
Found 2745156 threads
-
0 VotesAdd Minutes to Time (DateTime)
Do you mean to say one minute extra or you want to get rid of the minutes?Answered | 5 Replies | 5033 Views | Created by Sam233 - Monday, June 14, 2010 2:46 PM | Last reply by Suresh Kumar D - Tuesday, June 15, 2010 7:50 AM
-
0 Votes
How to Convert String to DateTime and Add 5 Minutes to it?
DateTime dt = DateTime.ParseExact( "20090925 235959", "yyyyMMdd HHmmss", CultureInfo.CurrentCulture); // ...Answered | 3 Replies | 3871 Views | Created by EdwardKoo77 - Friday, September 25, 2009 10:12 AM | Last reply by insigniya - Friday, September 25, 2009 9:17 PM -
0 Votes
Adding Minutes to DateTime Field
Here it is =Format(today(), "hh:mm:ss")Answered | 3 Replies | 7531 Views | Created by Sam233 - Tuesday, June 8, 2010 1:51 PM | Last reply by Suresh Kumar D - Tuesday, June 8, 2010 2:28 PM -
0 Votes
Datetime format merge with varchar
I will need to create a new field, which is in datetime format by merging the hour:minute and the date in Create_date,.Answered | 5 Replies | 2656 Views | Created by stephen huo - Friday, March 23, 2012 12:23 PM | Last reply by stephen huo - Friday, March 23, 2012 1:46 PM -
0 Votes
change datetime picker format
To put it stronger: Don't try to fix this code, because if you try to save datetimes in a certain format, you haven't understood a datetime value only is the ...Answered | 2 Replies | 768 Views | Created by BONIETE - Friday, March 25, 2016 9:10 PM | Last reply by Olaf Doschke - Monday, March 28, 2016 10:15 AM -
0 Votes
datetime format
declare @dt datetime set @dt = getdate() select convert(varchar, @dt, 101) + ' ' + ...Answered | 4 Replies | 4917 Views | Created by justin_rock - Tuesday, February 15, 2011 6:07 PM | Last reply by justin_rock - Tuesday, February 15, 2011 9:26 PM -
0 Votes
Formatting datetime
Hi, you can format your DateTime object using String property String datestr = ...Answered | 2 Replies | 3108 Views | Created by SuzieQ414 - Monday, December 7, 2009 3:52 PM | Last reply by Suresh Deoda - Tuesday, December 8, 2009 6:08 AM -
3 Votes
datetime format?
For exampe, a DateTime value (read from a SQL datetime data type), can be formatted as you specified in C# with: var myDateTimeString = ...Answered | 5 Replies | 3772 Views | Created by gm1924 - Monday, June 18, 2012 11:59 AM | Last reply by Dan Guzman - Wednesday, June 20, 2012 4:46 AM -
11 Votes
DateTime is stored as an int.
* It might be different format all together of course and we dont have any starting point unless we will get more information or someone will recugnize this specific ...Answered | 10 Replies | 1396 Views | Created by Timothy_Schryver - Wednesday, July 9, 2014 10:25 PM | Last reply by pituach - Tuesday, August 5, 2014 5:06 PM -
3 Votes
Datetime cutom format
Hello Bader, Please try the following datetime conversion format.Answered | 5 Replies | 2939 Views | Created by Nadim2522 - Wednesday, September 19, 2012 1:48 PM | Last reply by SQL Novice 01 - Wednesday, September 19, 2012 2:16 PM -
2 Votes
datetime format on C# WinForm
Try using TryParseExact() method: string strDate1 = "30/12/2012"; string strDate2 = "12/30/2012"; string[] dates = new string[] {strDate1, strDate2 ...Answered | 3 Replies | 4572 Views | Created by E_gold - Monday, May 21, 2012 8:19 PM | Last reply by Mitja Bonca - Monday, May 21, 2012 9:25 PM -
3 Votes
DateTime format problem ( Local DateTime)
Thanks again Want to add MVP with my name.Answered | 7 Replies | 2033 Views | Created by bahushekh - Tuesday, August 16, 2011 3:15 PM | Last reply by SJWhiteley - Wednesday, August 17, 2011 7:35 PM -
1 Votes
Format datetime to date
One of the options is to add one more column to your dimension.Answered | 6 Replies | 3897 Views | Created by Leo00 - Tuesday, January 21, 2014 8:26 PM | Last reply by Leo00 - Thursday, January 23, 2014 2:49 PM -
1 Votes
update Minutes value in the datetime column
I was showing you an example hoping you'll figure out how to turn SELECT (you need it to test first) into UPDATE.Answered | 13 Replies | 3365 Views | Created by John Fend - Thursday, April 12, 2012 8:25 PM | Last reply by sql393 - Thursday, April 12, 2012 9:16 PM -
13 Votes
What is the simple syntax to add hours and minutes?
Here it is how I tested ...Answered | 36 Replies | 4838 Views | Created by Larry_Nuñez - Wednesday, September 17, 2014 4:10 PM | Last reply by Olaf Doschke - Friday, September 26, 2014 5:56 AM -
0 Votes
Datetime Formats
I have a datetime field...Answered | 17 Replies | 1787 Views | Created by Desigal59 - Friday, January 20, 2017 10:36 PM | Last reply by Sam Zha - Tuesday, February 7, 2017 3:17 AM -
3 Votes
Format Datetime type in column
It's a common misunderstanding that you can insert and store a date into a datetime datatype in a certain format or style.Answered | 5 Replies | 6828 Views | Created by Ha Duong - Monday, September 10, 2007 12:06 PM | Last reply by richbrownesq - Wednesday, September 12, 2007 10:33 AM -
0 Votes
DATETIME Format
The following page deals with the same topic: http://www.sqlusa.com/bestpractices2008/between-dates/ SQL Server 2008 DATE data type offers a relief from the ...Answered | 8 Replies | 5656 Views | Created by SQL_1980 - Monday, May 16, 2011 9:52 AM | Last reply by Kalman Toth - Monday, May 16, 2011 4:36 PM -
1 Votes
Compress the DateTime to Minutes
Declare @myTable Table (DateField DateTime, TotalTime Numeric(18, 0), QuarterTime Numeric(18, 0), HalfTime Numeric(18, 0)) INsert Into @myTable Select ...Answered | 5 Replies | 2892 Views | Created by K.Kalyan - Monday, August 15, 2011 10:23 PM | Last reply by Gert-Jan Strik - Tuesday, August 16, 2011 8:04 AM -
1 Votes
How to convert datetime to time in 24 hrs format?
Vicky - If you have value in the format '2012-12-26 01:00:00.000' only then how will you recognize if it's am or pm?Answered | 8 Replies | 49124 Views | Created by vicky Bangalore - Wednesday, December 26, 2012 4:35 AM | Last reply by Ahsan Kabir - Wednesday, December 26, 2012 5:27 AM - Items 1 to 20 of 2745156 Next ›
No announcements
