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