Dating for DBAs

  • Duncan Pryde

    SSCertifiable

    Points: 7956

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

  • UMG Developer

    SSChampion

    Points: 13482

    Nice question, thanks!

    How many people actually use the ODBC date literals?

  • SQLRNNR

    SSC Guru

    Points: 281205

    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

  • SQLRNNR

    SSC Guru

    Points: 281205

    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

  • UMG Developer

    SSChampion

    Points: 13482

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

  • tejaswini.patil

    SSCommitted

    Points: 1782

    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.

  • Nakul Vachhrajani

    SSChampion

    Points: 10160

    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
    Be courteous. Drive responsibly.

    Follow me on
    Twitter: @sqltwins

  • jurgen.asselman

    Old Hand

    Points: 366

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

    Learned something though... "Read carefully"

  • M&M

    SSC-Insane

    Points: 21679

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

    M&M

  • paul.knibbs

    SSCoach

    Points: 15270

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

  • BrainDonor

    SSCoach

    Points: 19207

    Nice question - the links are particularly useful.

    Steve Hall
    Linkedin
    Blog Site

  • Chris Houghton

    SSCrazy

    Points: 2497

    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 😉

  • cdiebolt

    Ten Centuries

    Points: 1043

    Add one more european developer! 😉

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

  • cengland0

    SSCertifiable

    Points: 6102

    Good question, I lost 2 points but learned something.

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    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