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 Saturday, March 9, 2013 6:27 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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

Before posting a performance problem please read
Post #1428945
Posted Saturday, March 9, 2013 11:04 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 10:38 AM
Points: 386, Visits: 366
This was a tough one for me. I didn't know the default cut off year. thanks.


--------------------------------------------------------------------------------------
Hai Ton
My Db4Breakfast blog.
Post #1428957
Posted Sunday, March 10, 2013 12:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Thank Ron



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1428960
Posted Sunday, March 10, 2013 1:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Thanks Ron for question. i learn something new !!!.



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1428961
Posted Sunday, March 10, 2013 3:05 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 7,860, Visits: 9,606
Nice question and good explanation. Thanks Ron.

Tom
Post #1429022
Posted Sunday, March 10, 2013 10:48 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
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
Post #1429069
Posted Sunday, March 10, 2013 11:15 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 17,967, Visits: 15,975
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
Post #1429075
Posted Sunday, March 10, 2013 11:19 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:02 AM
Points: 1,372, Visits: 1,566
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
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1429076
Posted Monday, March 11, 2013 12:57 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:43 AM
Points: 1,945, Visits: 2,386
Hi,

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



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1429099
Posted Monday, March 11, 2013 1:47 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
kapil_kk (3/11/2013)
Hi,

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


Inscrutable , is that the right word

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
Post #1429104
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse