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 - 3 Expand / Collapse
Author
Message
Posted Monday, March 11, 2013 2:35 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 1,952, Visits: 2,396
thanks for the explanation....
Previously I didn't check the link.. after reading explanation I check that link and read that fully and its clear my doubts..
Thanks Ron for the question that make me learn new thing today



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1429112
Posted Monday, March 11, 2013 2:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:23 AM
Points: 1,409, Visits: 1,316
Thank you for a nice one question.



See, understand, learn, try, use efficient
© Dr.Plch
Post #1429113
Posted Monday, March 11, 2013 3:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:37 AM
Points: 1,037, Visits: 2,341
Thank you for the question. I got it right as I knew this. :)

(and I was expecting to see this "2050-01-27" as one of the answers for value-2)


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1429123
Posted Monday, March 11, 2013 4:05 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:56 PM
Points: 4,119, Visits: 5,485
L' Eomot Inversé (3/10/2013)
Nice question and good explanation. Thanks Ron.

+1

Thanks, Ron


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1429132
Posted Monday, March 11, 2013 4:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 6,098, Visits: 8,367
Good question on a feature that, hopefully, nobody ever relies on anymore. :)

Minor issues: it looks like the distracter options for value 1 and value 2 have been switched, and there was only one answer option for value 4.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1429157
Posted Monday, March 11, 2013 5:22 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, November 24, 2014 10:03 AM
Points: 1,895, Visits: 2,194
As I post this, answer four has the lowest correct percentage of the four correct answers, an yet it is the only one without a valid alternative. Hmmmm ...

Thanks Ron for the question. Had to get the cobwebs out and finish my breakfast before I clicked any answers. Learned the hard way about Monday morning questions.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1429173
Posted Monday, March 11, 2013 6:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 7,868, Visits: 9,607
Hugo Kornelis (3/11/2013)
Good question on a feature that, hopefully, nobody ever relies on anymore. :)
It always surpriseded me that anyone relied on it, except in early cobol programs where dates were strings and every byte counted. After all, 64 bit time - often represented as microseconds since 1900-01-01T00:00:00.000000, but sometimes 32-bit date (days) and 32-bit time (microseconds - a serious waste of 3 bits there ) - has been used in many languages since about 1968, so that string representations of dates were no longer a storage issue except for cobol programmers and those addicted to text strings for dates.

Minor issues: it looks like the distracter options for value 1 and value 2 have been switched, and there was only one answer option for value 4.

The switch of distractors maybe did no harm - it seems somewhat incredible, but to date 12% of people picked the distractor for value 1, apparently believing that a two digit year 49 could stand for a 4-digit year ending in 50, while only 9% picked the distractor for value 3 which required a far less bizarre mistake. But perhaps the craziest result is that 10% failed to get value 4 right although no wrong option was provided , although that 5% could believe that two different values were both correct for value 1 is also rather surprising.


Tom
Post #1429218
Posted Monday, March 11, 2013 6:36 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
Good one! Thanks for the Monday morning question that I was able to get correct.
Post #1429232
Posted Monday, March 11, 2013 7:04 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, November 21, 2014 1:23 PM
Points: 1,951, Visits: 1,473
Excellent question. I definitely learned something today.



Everything is awesome!
Post #1429244
Posted Monday, March 11, 2013 7:36 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 3,388, Visits: 2,021
Nice question. I didn't know about the cutoff year either.
Post #1429261
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse