DATETIME Puzzle

  • Comments posted to this topic are about the item DATETIME Puzzle

  • Good question, but a bit easy for 2 points.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • 2 points for so an easy question? Nice! 😀

  • change your language settings and you Could get 0

  • Thanks for the question.

    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

  • Koen Verbeeck (11/17/2011)


    Good question, but a bit easy for 2 points.

    After Che Guevara's question from yesterday, I'll take the easy two points.

    "I know you are here to kill me. Shoot, coward, you are only going to kill a man."

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • This wasn't totally easy. You really need to focus on the time part of the question. Thanks for submitting.

    http://brittcluff.blogspot.com/

  • Good question with a good explanation the presents a learning experience for those who got tripped up on either the dates or the BETWEEN.

    Thanks,

    Matt

  • I've seen this crop up enough time on the forums to see why it rates 2 points.

    While the answer is super-easy if you know DATETIME, this question highlights one of the easiest mistakes for a beginner to make, and one that has serious real-world implications.

  • Good Question. Was just working with this scenario...

  • I didn't see anything as to what question we were supposed to answer. Luckily I guessed correctly that we were supposed to select how many rows were returned by the query.

    Tony
    ------------------------------------
    Are you suggesting coconuts migrate?

  • tabinsc (11/17/2011)


    I didn't see anything as to what question we were supposed to answer. Luckily I guessed correctly that we were supposed to select how many rows were returned by the query.

    The question is written in large letters, although with a typo ("may" instead of "many") 🙂

    How may rows will be returned by following query?

  • A very easy question, unless you temporarily forget how to count :blush:

  • Good question, thanks.

  • sknox (11/17/2011)


    I've seen this crop up enough time on the forums to see why it rates 2 points.

    While the answer is super-easy if you know DATETIME, this question highlights one of the easiest mistakes for a beginner to make, and one that has serious real-world implications.

    Hear! Hear!

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

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