SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DATETIME - 3


DATETIME - 3

Author
Message
kapil_kk
kapil_kk
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5394 Visits: 2767
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/
honza.mf
honza.mf
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2569 Visits: 1323
Thank you for a nice one question.



See, understand, learn, try, use efficient
© Dr.Plch
Raghavendra Mudugal
Raghavendra Mudugal
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3380 Visits: 2958
Thank you for the question. I got it right as I knew this. Smile

(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.
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17317 Visits: 7421
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”
Hugo Kornelis
Hugo Kornelis
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18971 Visits: 12426
Good question on a feature that, hopefully, nobody ever relies on anymore. Smile

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
Thomas Abraham
Thomas Abraham
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3859 Visits: 2256
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
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26203 Visits: 12506
Hugo Kornelis (3/11/2013)
Good question on a feature that, hopefully, nobody ever relies on anymore. Smile
It always surpriseded me that anyone relied on it, except in early cobol programs where dates were strings and every byte counted. Sick 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 :heheSmile - 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 w00t, although that 5% could believe that two different values were both correct for value 1 is also rather surprising. Blink

Tom

(Bob Brown)
(Bob Brown)
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1065 Visits: 1145
Good one! Thanks for the Monday morning question that I was able to get correct.
Dana Medley
Dana Medley
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3148 Visits: 1707
Excellent question. I definitely learned something today.



Everything is awesome!
Ken Wymore
Ken Wymore
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6624 Visits: 2399
Nice question. I didn't know about the cutoff year either.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search