InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 20:22:36 GMT20http://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxThis was an excellent question. Got it wrong but sure learned something.Tue, 27 Dec 2011 11:02:21 GMTSqlMelhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx"MUST READ THE WHOLE QUESTION... MUST READ THE WHOLE QUESTION... MUST READ THE WHOLE QUESTION... MUST READ THE WHOLE QUESTION... MUST READ THE WHOLE QUESTION... "Of course I answered all of them.. dangThu, 10 Nov 2011 11:25:15 GMTJohn Esraelo-498130http://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxGreat question!Mon, 06 Jun 2011 08:06:09 GMTRafael Krisllerhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxDate questions are funThu, 14 Apr 2011 18:17:55 GMTJamie Longstreet-481950http://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxNice question, thanks.Sun, 10 Apr 2011 23:37:00 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]shivani_aggarwal09 (4/8/2011)[/b][hr]all the formts are correct their is no error. firstly among the 4 we can not seclect any 2 bcoz of the all 4 are right. i was schoked when my answer goes wrong when i chose all then i chech all the formets in the sql 2005 their is no error. plz clear me how my answer is wrong.[/quote]All four will work with some language settings. Reread the explanation and discussion thread for more information on this.Fri, 08 Apr 2011 05:40:20 GMTRose Budhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxall the formts are correct their is no error. firstly among the 4 we can not seclect any 2 bcoz of the all 4 are right. i was schoked when my answer goes wrong when i chose all then i chech all the formets in the sql 2005 their is no error. plz clear me how my answer is wrong.Fri, 08 Apr 2011 00:05:42 GMTshivani aggarwalhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]rmechaber (4/6/2011)[/b][hr][quote][b]Duncan Pryde (4/6/2011)[/b][hr]I'm glad people are liking the question - thanks for the positive comments everyone.I was motivated to come up with the question after following a discussion relating to a QotD from a few weeks ago. There was some (at times quite heated!) debate around language-independent date formats, so I thought it would be good material for a question, and hopefully some more discussion.Incidentally, there's a "second date" scheduled to be published next week, so anything you read in those links could be handy... :cool:[/quote]OK, Duncan, I got this wrong, and [u]I'm[/u] the one who posted the link last week to Tibor Karaszi's excellent write-up!:ermm:I don't use the {} ODBC escape format, so I missed that one. Guess I learned something, so thanks.Rich[/quote]Hi Rich - I couldn't remember who it was who'd posted the link, but after dipping into it a few times and reading the BOL page, a couple of questions came to mind - so thanks for sowing the seed!Thu, 07 Apr 2011 01:24:26 GMTDuncan Prydehttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]Duncan Pryde (4/6/2011)[/b][hr]I'm glad people are liking the question - thanks for the positive comments everyone.I was motivated to come up with the question after following a discussion relating to a QotD from a few weeks ago. There was some (at times quite heated!) debate around language-independent date formats, so I thought it would be good material for a question, and hopefully some more discussion.Incidentally, there's a "second date" scheduled to be published next week, so anything you read in those links could be handy... :cool:[/quote]I remembered that discussion and got the answer correct as a result! (I knew enough to test these possibilities out in SSMS with language set to British and then to French because I knew they would probably all work with my current setting of US English.) Two points is a good reward for reading, retaining, and applying information introduced in QOTD discussions.Wed, 06 Apr 2011 12:19:36 GMTRose Budhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxTerrific question. For some reason dates are not my best topic.Wed, 06 Apr 2011 09:30:58 GMTmtillman-921105http://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]Duncan Pryde (4/6/2011)[/b][hr]I'm glad people are liking the question - thanks for the positive comments everyone.I was motivated to come up with the question after following a discussion relating to a QotD from a few weeks ago. There was some (at times quite heated!) debate around language-independent date formats, so I thought it would be good material for a question, and hopefully some more discussion.Incidentally, there's a "second date" scheduled to be published next week, so anything you read in those links could be handy... :cool:[/quote]OK, Duncan, I got this wrong, and [u]I'm[/u] the one who posted the link last week to Tibor Karaszi's excellent write-up!:ermm:I don't use the {} ODBC escape format, so I missed that one. Guess I learned something, so thanks.RichWed, 06 Apr 2011 09:28:18 GMTrmechaberhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxExcellent question. Got it wrong though, but learned something new today. Thanks,SureshWed, 06 Apr 2011 09:19:25 GMTSuriihttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]paul.knibbs (4/6/2011)[/b][hr]Pity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong? :-)[/quote]I would bet it is a greater percentage than US dba's.Many US dba's and database developers have worked on at least one project with Canadian customers. They use the dd-mm-yyyy data format. :smooth:It is my understanding the all of Great Briton uses the same date format.Wed, 06 Apr 2011 08:31:37 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxGreat question. Love the title.Wed, 06 Apr 2011 08:31:13 GMTCliff Joneshttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]UMG Developer (4/5/2011)[/b][hr][quote][b]CirquedeSQLeil (4/5/2011)[/b][hr][quote][b]UMG Developer (4/5/2011)[/b][hr]How many people actually use the ODBC date literals?[/quote]I think very few in comparison.[/quote]Yeah, I think the number of people answering correctly shows that. (Currently 33% of the 24 people that have answered.)[/quote]I would have to agree that using the ODBC date literals is "Old School" in a bad way.I had a project back in the late 90's that had to show dates in Cannadian and US format.We used the second format to transfer the dates as strings from the UI to SQL and back.This yyyyddmm string format tested on SQL 7 and SQL 2000 as being 50% faster during a load.I tested today when I saw the question and it still round trip faster to format the date as string in the yyyyddmm format and pass to SQL for Multilaguage and Multiformat support. Formating as string YYYY-dd-mm and doing a cast using ODBC date literals just takes longer.Wed, 06 Apr 2011 08:26:10 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]cdiebolt (4/6/2011)[/b][hr]Add one more european developer! ;-)I didn't know that the 2nd answer is dateformat dependent. :Whistling:[/quote]Me either... I was pretty sure 2011-04-28 was a dateformat neutral date... :(Just a silly ANSI standard, but not dateformat neutral... :/Of course I missed the hint (select 2)... which might have helped.Wed, 06 Apr 2011 07:22:07 GMTmtassinhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxThis was a great question. I got it wrong but appreciate the information. Thanks!- webrunnerWed, 06 Apr 2011 07:15:40 GMTwebrunnerhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]paul.knibbs (4/6/2011)[/b][hr]Pity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong? :-)[/quote]I'll admit that I deliberately chose '04-28-2011' as a potential answer rather than '28-04-2011', but this was more because I reckoned there might be more people using the first format in their daily lives, rather than being a deliberate attempt to target our friends across the pond. Honest.Wed, 06 Apr 2011 07:08:17 GMTDuncan Prydehttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxI'm glad people are liking the question - thanks for the positive comments everyone.I was motivated to come up with the question after following a discussion relating to a QotD from a few weeks ago. There was some (at times quite heated!) debate around language-independent date formats, so I thought it would be good material for a question, and hopefully some more discussion.Incidentally, there's a "second date" scheduled to be published next week, so anything you read in those links could be handy... :cool:Wed, 06 Apr 2011 06:39:12 GMTDuncan Prydehttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxExcellent question. Got it wrong - but learned a lot.:-)Wed, 06 Apr 2011 06:09:50 GMTsjimmohttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]Hugo Kornelis (4/6/2011)[/b][hr]Few, I would hope ;-)[/quote]Actually, the ODBC format can be quite useful when you are developing a system fetching data in may different data sources, as you can unify the way you write you dates in your queries. But beside that type of usage, I agree it's probably best to use another syntax.Wed, 06 Apr 2011 03:32:39 GMTcdiebolthttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxGood question. Being in London (where we speak a 'foreign' version of English) helped to get it right.:-)Wed, 06 Apr 2011 03:31:19 GMTRichard Warrhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxNice question! And I just love the punny title.[quote][b]UMG Developer (4/5/2011)[/b][hr]Nice question, thanks!How many people actually use the ODBC date literals?[/quote]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.Wed, 06 Apr 2011 02:57:29 GMTHugo Kornelishttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxGood question, I lost 2 points but learned something.Wed, 06 Apr 2011 02:40:42 GMTcengland0http://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxAdd one more european developer! ;-)I didn't know that the 2nd answer is dateformat dependent. :Whistling:Wed, 06 Apr 2011 02:24:21 GMTcdiebolthttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]paul.knibbs (4/6/2011)[/b][hr]Pity you can't split the results by nationality--[b]I wonder how many British or European DBAs would get this one wrong[/b]? :-)[/quote]At least one ;-)Wed, 06 Apr 2011 02:17:35 GMTChris Houghtonhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxNice question - the links are particularly useful.Wed, 06 Apr 2011 01:47:03 GMTBrainDonorhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxPity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong? :-)Wed, 06 Apr 2011 01:38:51 GMTpaul.knibbshttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxGood question. If the hint for choosing 2 options was not there, I would have got this wrong. :-)Wed, 06 Apr 2011 00:36:56 GMTmohammed moinudheenhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxsame here, I overlooked the "regardless of any language" piece, so selected all 4 too...Learned something though... "Read carefully"Wed, 06 Apr 2011 00:34:07 GMTjurgen.asselmanhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]UMG Developer (4/5/2011)[/b][hr]Nice question, thanks!How many people actually use the ODBC date literals?[/quote]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!Wed, 06 Apr 2011 00:33:28 GMTNakul Vachhrajanihttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxThanks 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.Wed, 06 Apr 2011 00:30:36 GMTtejaswini.patilhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]CirquedeSQLeil (4/5/2011)[/b][hr][quote][b]UMG Developer (4/5/2011)[/b][hr]How many people actually use the ODBC date literals?[/quote]I think very few in comparison.[/quote]Yeah, I think the number of people answering correctly shows that. (Currently 33% of the 24 people that have answered.)Tue, 05 Apr 2011 23:06:03 GMTUMG Developerhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxI think this was a great question and quite usefulTue, 05 Apr 2011 22:18:57 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspx[quote][b]UMG Developer (4/5/2011)[/b][hr]Nice question, thanks!How many people actually use the ODBC date literals?[/quote]I think very few in comparison.Tue, 05 Apr 2011 22:18:35 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxNice question, thanks!How many people actually use the ODBC date literals?Tue, 05 Apr 2011 20:55:32 GMTUMG Developerhttp://www.sqlservercentral.com/Forums/Topic1088994-2901-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/72816/">Dating for DBAs</A>[/B]Tue, 05 Apr 2011 20:54:50 GMTDuncan Pryde