No announcements
Found 736201 threads
-
0 Votesreading datetime in a specific format
There is lot of content about how to print a date in different formats.Answered | 4 Replies | 2963 Views | Created by Raj_Microsoft - Tuesday, July 6, 2010 9:25 AM | Last reply by TheKiller556 - Tuesday, July 6, 2010 1:31 PM
-
2 Votes
Specific datetime format
SET NOCOUNT ON DECLARE @startTime DATETIME = CURRENT_TIMESTAMP DECLARE @dts TABLE (datetime DATETIME) WHILE (SELECT COUNT(*) FROM @dts)Answered | 8 Replies | 1009 Views | Created by Kirkee - Tuesday, January 26, 2016 8:00 PM | Last reply by Patrick Hurst - Wednesday, January 27, 2016 5:14 PM -
0 Votes
how to convert date in number in to datetime specific format
try to pass the date in yyyymmdd format, it is easier this way.Answered | 4 Replies | 3149 Views | Created by hygrsrir1987 - Wednesday, December 19, 2012 9:32 AM | Last reply by Satheesh Variath - Wednesday, December 19, 2012 10:19 AM -
0 Votes
Check the DateTime format
A DateTime field doesn't have any specific format and a database doesn't store a datetime value in any particular format.Answered | 2 Replies | 1155 Views | Created by RohitrkKUmar - Tuesday, May 12, 2015 12:03 PM | Last reply by Magnus (MM8) - Tuesday, May 12, 2015 3:01 PM -
0 Votes
Parse a date time string in specific format to DateTime of specific culture
A DateTime has no culture, just the parsing and output are culture dependant.Answered | 1 Replies | 3656 Views | Created by Sandeep Nakarmi - Technical Consultant - Friday, November 7, 2008 8:20 AM | Last reply by Ron.Whittle - Friday, November 7, 2008 8:43 AM -
0 Votes
Formatting datetime
Hi, you can format your DateTime object using String property String datestr = ...Answered | 2 Replies | 3291 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
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 | 7041 Views | Created by Ha Duong - Monday, September 10, 2007 12:06 PM | Last reply by richbrownesq - Wednesday, September 12, 2007 10:33 AM -
3 Votes
DateTime format problem ( Local DateTime)
In my opinion, storing the datetimes as strings is a backwards step.Answered | 7 Replies | 2219 Views | Created by bahushekh - Tuesday, August 16, 2011 3:15 PM | Last reply by SJWhiteley - Wednesday, August 17, 2011 7:35 PM -
0 Votes
Converting datetime format
I am seeing the same YYYY-MM-DD format in new_date instead of MM-DD-YYYY YYYY-MM-DD is the ANSI (the BEST) string date format.Answered | 4 Replies | 1768 Views | Created by rockstar283 - Monday, March 11, 2013 9:18 PM | Last reply by Kalman Toth - Monday, March 11, 2013 10:01 PM -
0 Votes
SQL datetime format
I will use the ISO 8601 format in future.Answered | 5 Replies | 5280 Views | Created by Alain Dekker - Tuesday, September 20, 2011 2:36 PM | Last reply by Alain Dekker - Thursday, September 22, 2011 11:13 AM -
1 Votes
Custom Datetime format
hello, i'm looking to convert a datetime in a specific format.Answered | 1 Replies | 2610 Views | Created by Aussie - Wednesday, September 2, 2009 9:41 AM | Last reply by boothwine - Wednesday, September 2, 2009 9:49 AM -
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 | 1063 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 formate C#
Based on your issue please refer ...Answered | 5 Replies | 3253 Views | Created by It_s Meee - Thursday, June 17, 2010 7:14 AM | Last reply by Fafafaalex - Friday, June 18, 2010 4:08 AM -
0 Votes
DateTime format conversion in c#
The appearance of a DateTime value is the result of a formatting operation.Answered | 4 Replies | 7955 Views | Created by Kevin Peterson. _ - Wednesday, March 25, 2009 1:39 PM | Last reply by Guo Surfer - Wednesday, April 1, 2009 4:08 AM -
0 Votes
datetime format
declare @dt datetime set @dt = getdate() select convert(varchar, @dt, 101) + ' ' + ...Answered | 4 Replies | 5184 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
Datetime Formats
I have a datetime field...Answered | 17 Replies | 2023 Views | Created by Desigal59 - Friday, January 20, 2017 10:36 PM | Last reply by Sam Zha - Tuesday, February 7, 2017 3:17 AM -
0 Votes
Nvarchar to datetime format
As suggested by Olaf, datetime don't have any format information it stores as int in this case assuming you are querying data using ...Answered | 6 Replies | 3851 Views | Created by Abhisek Mondal - Tuesday, April 11, 2017 10:12 AM | Last reply by Abhisek Mondal - Tuesday, April 11, 2017 1:57 PM -
1 Votes
Format datetime to date
I converted all the datetime columns to date datatype in my views used by cube.Answered | 6 Replies | 4163 Views | Created by Leo00 - Tuesday, January 21, 2014 8:26 PM | Last reply by Leo00 - Thursday, January 23, 2014 2:49 PM -
3 Votes
Datetime cutom format
Hello Bader, Please try the following datetime conversion format.Answered | 5 Replies | 3125 Views | Created by Nadim2522 - Wednesday, September 19, 2012 1:48 PM | Last reply by SQL Novice 01 - Wednesday, September 19, 2012 2:16 PM -
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 | 5865 Views | Created by SQL_1980 - Monday, May 16, 2011 9:52 AM | Last reply by Kalman Toth - Monday, May 16, 2011 4:36 PM - Items 1 to 20 of 736201 Next ›
No announcements
