Home Forums Article Discussions Article Discussions by Author Discuss content posted by Richard Warr Fun(?) with DATETIME2 RE: Fun(?) with DATETIME2

  • August 10, 2011 at 10:06 am

    #1366706

    Tom.Thomson (8/10/2011)

    . . .

    Not in most countries except Britain (note single t), in all countries including Britain. Datetime2 uses the Gregorian calendar, not any other calendar, so it is not a locale dependent type.

    Hmm... maybe it is not quite Gregorian. If you run this, --

    DECLARE @type2 DATETIME2(7) = '1582-10-10';

    PRINT DATEPART( dw, @type2 );

    you will get 1, i.e., Monday, but that is wrong because there was no October 10 in 1582.