Click here to Skip to main content
15,668,691 members
Home / Discussions / C#
   

C#

 
GeneralRe: Import XML file without stylesheet Pin
Bernhard Hiller13-Jul-14 21:40
Bernhard Hiller13-Jul-14 21:40 
QuestionError : Method name expected // how do I fix this error. please Pin
Member 1074342211-Jul-14 17:47
Member 1074342211-Jul-14 17:47 
AnswerRe: Error : Method name expected // how do I fix this error. please Pin
Richard.Berry10011-Jul-14 19:19
Richard.Berry10011-Jul-14 19:19 
SuggestionRe: Error : Method name expected // how do I fix this error. please Pin
Richard MacCutchan11-Jul-14 21:36
mveRichard MacCutchan11-Jul-14 21:36 
QuestionWhy Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
arvind mepani11-Jul-14 4:42
arvind mepani11-Jul-14 4:42 
AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
Retro61711-Jul-14 5:11
Retro61711-Jul-14 5:11 
AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
Richard MacCutchan11-Jul-14 5:19
mveRichard MacCutchan11-Jul-14 5:19 
AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
Richard Deeming11-Jul-14 5:21
mveRichard Deeming11-Jul-14 5:21 
Converting strings to dates in SQL Server depends on the current DATEFORMAT option[^]. This option will be one of mdy, dmy, ymd, ydm, myd, or dym; the default is mdy.

You should try to avoid converting strings to dates (or vice-versa) in SQL; that sort of code belongs in the user-interface code. However, if you absolutely have to specify a date as a string, you should use an unambiguous format - namely yyyyMMdd. Don't add any separators, as dates with separators are still liable to change based on the culture and settings.

MSDN has a list of the supported string literal formats for dates:
http://msdn.microsoft.com/en-gb/library/ms187819.aspx#sectionToggle1[^]



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
OriginalGriff11-Jul-14 5:55
mvaOriginalGriff11-Jul-14 5:55 
AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
Bernhard Hiller13-Jul-14 21:45
Bernhard Hiller13-Jul-14 21:45 
QuestionILnumerics illustrate 3D coordinates Pin
gzax11-Jul-14 3:47
gzax11-Jul-14 3:47 
AnswerRe: ILnumerics illustrate 3D coordinates Pin
OriginalGriff11-Jul-14 3:56
mvaOriginalGriff11-Jul-14 3:56 
QuestionCrystal Report Runtime command line Pin
Amr Muhammed11-Jul-14 3:33
Amr Muhammed11-Jul-14 3:33 
AnswerRe: Crystal Report Runtime command line Pin
Eddy Vluggen11-Jul-14 7:16
professionalEddy Vluggen11-Jul-14 7:16 
QuestionPass byte.TryParse() or int.tryParse() as argument Pin
Mc_Topaz11-Jul-14 1:03
Mc_Topaz11-Jul-14 1:03 
AnswerRe: Pass byte.TryParse() or int.tryParse() as argument Pin
Richard Deeming11-Jul-14 1:29
mveRichard Deeming11-Jul-14 1:29 
GeneralRe: Pass byte.TryParse() or int.tryParse() as argument Pin
Mc_Topaz11-Jul-14 1:45
Mc_Topaz11-Jul-14 1:45 
Questionwhat exactly below code do Pin
anil42010-Jul-14 21:24
anil42010-Jul-14 21:24 
SuggestionRe: what exactly below code do Pin
Hemant Singh Rautela10-Jul-14 21:33
professionalHemant Singh Rautela10-Jul-14 21:33 
AnswerRe: what exactly below code do Pin
OriginalGriff10-Jul-14 21:39
mvaOriginalGriff10-Jul-14 21:39 
SuggestionRe: what exactly below code do Pin
ZurdoDev11-Jul-14 1:47
professionalZurdoDev11-Jul-14 1:47 
QuestionC# insert command error Pin
PJeffrey10-Jul-14 16:11
PJeffrey10-Jul-14 16:11 
AnswerRe: C# insert command error Pin
Dave Kreskowiak10-Jul-14 18:20
mveDave Kreskowiak10-Jul-14 18:20 
AnswerRe: C# insert command error Pin
jldavis515-Jul-14 8:13
jldavis515-Jul-14 8:13 
QuestionPrivate chat Pin
Member 1076298010-Jul-14 11:15
Member 1076298010-Jul-14 11:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.