Dating for DBAs

  • Comments posted to this topic are about the item Dating for DBAs

  • Nice question, thanks!

    How many people actually use the ODBC date literals?

  • 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

  • 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

  • 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.)

  • 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.

  • 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

  • same here, I overlooked the "regardless of any language" piece, so selected all 4 too...

    Learned something though... "Read carefully"

  • Good question. If the hint for choosing 2 options was not there, I would have got this wrong. 🙂

    M&M

  • Pity you can't split the results by nationality--I wonder how many British or European DBAs would get this one wrong? 🙂

  • Nice question - the links are particularly useful.

  • 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 😉

  • Add one more european developer! 😉

    I didn't know that the 2nd answer is dateformat dependent. :Whistling:

  • Good question, I lost 2 points but learned something.

  • 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.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Viewing 15 posts - 1 through 15 (of 37 total)

You must be logged in to reply to this topic. Login to reply