DATETIME Puzzle

Question

DATETIME Puzzle

Sunil Chandurkar

Right there with Babe

Points: 791
More actions
November 16, 2011 at 9:35 pm

#390884

Comments posted to this topic are about the item DATETIME Puzzle

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

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 SSCertifiable Points: 5617 More actions · Answer 2

palotaiarpad

SSCertifiable

Points: 5617

November 17, 2011 at 12:34 am

#1408990

2 points for so an easy question? Nice! 😀

53280comma1 Old Hand Points: 365 More actions · Answer 3

53280comma1

Old Hand

Points: 365

November 17, 2011 at 1:29 am

#1409010

change your language settings and you Could get 0

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

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 More actions · Answer 5

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 More actions · Answer 6

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 More actions · Answer 7

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: 12388 More actions · Answer 8

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: 3338 More actions · Answer 9

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

tabinsc SSCommitted Points: 1812 More actions · Answer 10

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 More actions · Answer 11

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: 11365 More actions · Answer 12

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

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 13

Daniel Bowlin

SSC-Dedicated

Points: 34566

November 17, 2011 at 8:13 am

#1409236

Good question, thanks.

Ola L Martins-329921 Mr or Mrs. 500 Points: 542 More actions · Answer 14

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!