DATETIME Puzzle

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sunil Chandurkar » DATETIME Puzzle

33 posts, Page 1 of 4

1 2 3 4 »»»

DATETIME Puzzle

Rate Topic

Display Mode

Topic Options

Author

Message

Sunil Chandurkar

Posted Wednesday, November 16, 2011 9:35 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, September 27, 2012 4:24 AM
Points: 253, Visits: 78

Comments posted to this topic are about the item DATETIME Puzzle

Post #1207220

Koen Verbeeck

Posted Thursday, November 17, 2011 12:00 AM

SSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:30 AM
Points: 9,410, Visits: 6,495

Good question, but a bit easy for 2 points.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1207256

palotaiarpad

Posted Thursday, November 17, 2011 12:34 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:07 AM
Points: 868, Visits: 339

2 points for so an easy question? Nice! BigGrin

Post #1207268

53280comma1

Posted Thursday, November 17, 2011 1:29 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 3:30 AM
Points: 325, Visits: 231

change your language settings and you Could get 0

Post #1207289

SQLRNNR

Posted Thursday, November 17, 2011 5:09 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 18,858, Visits: 12,443

Thanks for the question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1207398

Thomas Abraham

Posted Thursday, November 17, 2011 5:30 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 5:11 AM
Points: 1,168, Visits: 1,470

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

Please don't go. The drones need you. They look up to you.

Post #1207416

Britt Cluff

Posted Thursday, November 17, 2011 5:50 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247

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

http://brittcluff.blogspot.com/

Post #1207431

Mattrick

Posted Thursday, November 17, 2011 6:03 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 581, Visits: 700

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

Post #1207439

sknox

Posted Thursday, November 17, 2011 6:31 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:32 AM
Points: 1,059, Visits: 1,396

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.

Post #1207461

getoffmyfoot

Posted Thursday, November 17, 2011 7:15 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 1:09 PM
Points: 335, Visits: 391

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

Post #1207497

« Prev Topic | Next Topic »

33 posts, Page 1 of 4

1 2 3 4 »»»

Permissions