DATETIME - 3

Question

Post reply

DATETIME - 3

Ron McCullough

SSC Guru

Points: 63877
More actions
March 9, 2013 at 6:27 pm

#290856

Comments posted to this topic are about the item DATETIME - 3
If everything seems to be going well, you have obviously overlooked something.
Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]
March 11, 2013 at 4:05 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 37 total)

You must be logged in to reply to this topic. Login to reply

db4breakfast Ten Centuries Points: 1097 More actions · Answer 1

This was a tough one for me. I didn't know the default cut off year. thanks.

--------------------------------------------------------------------------------------
Hai Ton
My Db4Breakfast blog.

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 2

Thank Ron

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 3

Thanks Ron for question. i learn something new !!!. 🙂

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

TomThomson SSC Guru Points: 104773 More actions · Answer 4

Nice question and good explanation. Thanks Ron.

Tom

demonfox SSCertifiable Points: 6289 More actions · Answer 5

L' Eomot Inversé (3/10/2013)
Nice question and good explanation. Thanks Ron.

+1

I marked it too soon 😉

too soon to be correct 😛

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Thanks Ron.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lokesh Vij SSChampion Points: 10836 More actions · Answer 7

db4breakfast (3/9/2013)
This was a tough one for me. I didn't know the default cut off year. thanks.

+1

something new for me to learn as well.

Thanks Ron!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

kapil_kk SSC-Insane Points: 21316 More actions · Answer 8

Hi,

can someone plz explain it in a more simple manner..... explanation in QOTD is very inscrutable for me:cool:

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

demonfox SSCertifiable Points: 6289 More actions · Answer 9

kapil_kk (3/11/2013)
Hi,
can someone plz explain it in a more simple manner..... explanation in QOTD is very inscrutable for me:cool:

Inscrutable , is that the right word :ermm:

well, as explained in the explanation ..

1.

The two digit year cutoff option specifies an integer from 1753 to 9999 that represents the cutoff year for interpreting two-digit years as four-digit years.

So, for sql server to interpret Two digit year as Four digit year

2.

The default time span for SQL Server is 1950-2049,

It means , if you anything in between the above range .. it will interpret as current century ..

50 is 1950

51 is 1951

49 is 2049

48 is 2048

is that clear enough ??? 🙂

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

kapil_kk SSC-Insane Points: 21316 More actions · Answer 10

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 SSCertifiable Points: 5519 More actions · Answer 11

Thank you for a nice one question.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 12

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.

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 13

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/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/