Reputation
1,635
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 10 29
Newest
 Yearling
Impact
~122k people reached

Jan
28
awarded  Yearling
Dec
8
awarded  Nice Question
Nov
25
comment Understanding datetime formats in SQL Server
I'm used to an environment where if I don't provide a reference for every assertion, I'm automatically discounted as promoting cargo cult/voodoo/developer religious practices. I do think answers online are better with references rather than bald assertions (even just some script that anyone can run). In any case, thanks for the info! Perhaps I'll write a blog post that I can use as such a reference in the future.
Nov
25
comment Understanding datetime formats in SQL Server
I believe you! I tell other people the same thing (probably based on reading your material in the past). I'm just wondering if there's a reference source I can use. See the link I added to my previous comment that provides at least a starting point for the yyyymmdd format.
Nov
25
answered Understanding datetime formats in SQL Server
Nov
25
comment Understanding datetime formats in SQL Server
@AaronBertrand Do you have a Microsoft reference for these two formats being the only safe ones, or is this the product of trial and error experimentation? I'm just answering a question elsewhere and would like to provide a reference, if you know of one. Cast and Convert seemed a likely place to start, but there's nothing there (that I can find) about what formats are internaional date-safe without a specific format style provided. This comes closer, but still misses.
Aug
17
awarded  Nice Question
Jul
27
awarded  Caucus
May
25
awarded  Nice Answer
May
3
awarded  Taxonomist
Apr
17
awarded  Nice Question
Feb
25
comment Is it okay to put dots in SQL Server database names?
Why use a dash - when you can use an underscore _ and not have to enclose the name in square brackets at all?
Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Ugh... column names with spaces in them...
Feb
5
awarded  Self-Learner
Feb
5
revised Easily show rows that are different between two tables or queries
Add DDL and DML
Feb
5
revised Easily show rows that are different between two tables or queries
added 255 characters in body
Feb
5
revised Easily show rows that are different between two tables or queries
Formatting, changed alias style
Jan
28
awarded  Yearling
Dec
8
awarded  Popular Question
Sep
30
awarded  Explainer