Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

DATETIME Puzzle Expand / Collapse
Author
Message
Posted Wednesday, November 16, 2011 9:35 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 6:40 AM
Points: 253, Visits: 79
Comments posted to this topic are about the item DATETIME Puzzle
Post #1207220
Posted Thursday, November 17, 2011 12:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
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
Posted Thursday, November 17, 2011 12:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 1,348, Visits: 488
2 points for so an easy question? Nice!
Post #1207268
Posted Thursday, November 17, 2011 1:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Thursday, November 17, 2011 5:09 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:04 PM
Points: 17,729, Visits: 15,596
Thanks for the question.



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


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
Posted Thursday, November 17, 2011 5:30 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:17 PM
Points: 1,837, Visits: 2,180
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.
Connect to me on LinkedIn
Post #1207416
Posted Thursday, November 17, 2011 5:50 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
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
Posted Thursday, November 17, 2011 6:03 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:32 PM
Points: 581, Visits: 733
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
Posted Thursday, November 17, 2011 6:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:45 AM
Points: 1,333, Visits: 1,701
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
Posted Thursday, November 17, 2011 7:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 9:36 AM
Points: 340, Visits: 406
Good Question. Was just working with this scenario...
Post #1207497
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse