DATETIME Puzzle

  • Sunil Chandurkar

    Right there with Babe

    Points: 791

    Comments posted to this topic are about the item DATETIME Puzzle

  • Koen Verbeeck

    SSC Guru

    Points: 258942

    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

  • palotaiarpad

    SSCarpal Tunnel

    Points: 4889

    2 points for so an easy question? Nice! 😀

  • 53280comma1

    Old Hand

    Points: 365

    change your language settings and you Could get 0

  • SQLRNNR

    SSC Guru

    Points: 281210

    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

  • Thomas Abraham

    SSChampion

    Points: 10761

    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

  • Britt Cluff

    SSCertifiable

    Points: 5083

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

    http://brittcluff.blogspot.com/

  • Mattrick

    Ten Centuries

    Points: 1176

    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

  • sknox

    SSChampion

    Points: 12227

    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.

  • getoffmyfoot

    Hall of Fame

    Points: 3052

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

  • tabinsc

    SSCommitted

    Points: 1812

    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?

  • vk-kirov

    SSCertifiable

    Points: 7686

    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?

  • Toreador

    SSChampion

    Points: 11232

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

  • Daniel Bowlin

    SSC-Dedicated

    Points: 34566

    Good question, thanks.

  • Ola L Martins-329921

    Mr or Mrs. 500

    Points: 542

    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 33 total)

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