April 5, 2011 at 8:54 pm
Comments posted to this topic are about the item Dating for DBAs
April 5, 2011 at 8:55 pm
Nice question, thanks!
How many people actually use the ODBC date literals?
April 5, 2011 at 10:18 pm
UMG Developer (4/5/2011)
Nice question, thanks!How many people actually use the ODBC date literals?
I think very few in comparison.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2011 at 10:18 pm
I think this was a great question and quite useful
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2011 at 11:06 pm
CirquedeSQLeil (4/5/2011)
UMG Developer (4/5/2011)
How many people actually use the ODBC date literals?I think very few in comparison.
Yeah, I think the number of people answering correctly shows that. (Currently 33% of the 24 people that have answered.)
April 6, 2011 at 12:30 am
Thanks for the question.
I tried all 4 select statements in 2005 as well as in 2008 without changing LANGUATE 7 DATEFORMAT. All the 4 statements worked. So selected all of them.
I overlooked "regardless of any LANGUAGE or DATEFORMAT settings? (select 2)".
Lost the point.
It was a learning for me.
April 6, 2011 at 12:33 am
UMG Developer (4/5/2011)
Nice question, thanks!How many people actually use the ODBC date literals?
Talking of Dating...I do
Seriously, our product does use ODBC date literals, and hence this one was an easy one for me.
However, generally speaking, this is a fantastic question because it teaches a lot about how to generalize our code.
And, the subject is great as well.
Thank-you!
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
April 6, 2011 at 12:34 am
same here, I overlooked the "regardless of any language" piece, so selected all 4 too...
Learned something though... "Read carefully"
April 6, 2011 at 12:36 am
Good question. If the hint for choosing 2 options was not there, I would have got this wrong.
M&M
April 6, 2011 at 1:38 am
Pity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong?
April 6, 2011 at 2:17 am
paul.knibbs (4/6/2011)
Pity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong?
At least one
April 6, 2011 at 2:24 am
Add one more european developer!
I didn't know that the 2nd answer is dateformat dependent. :Whistling:
April 6, 2011 at 2:40 am
Good question, I lost 2 points but learned something.
April 6, 2011 at 2:57 am
Nice question! And I just love the punny title.
UMG Developer (4/5/2011)
Nice question, thanks!How many people actually use the ODBC date literals?
Few, I would hope
Luckily I have seen them before, and I knew which two answers are not correct, so from that I deduced that ODBC dates using yyyy-mm-dd must be language independent.
Viewing 15 posts - 1 through 15 (of 37 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy