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: Today @ 4:35 AM
Points: 12,208, Visits: 9,172
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: Wednesday, April 16, 2014 12:16 AM
Points: 1,232, Visits: 447
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 20,466, Visits: 14,097
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: 2 days ago @ 7:35 AM
Points: 1,625, Visits: 2,034
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: 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
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: Friday, April 04, 2014 8:53 AM
Points: 581, Visits: 721
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: 2 days ago @ 7:12 AM
Points: 1,247, Visits: 1,594
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, December 04, 2013 1:32 PM
Points: 335, Visits: 392
Good Question. Was just working with this scenario...
Post #1207497
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse