• And here's a really obvious (yeah right!) way of making Lynn's example work:

    declare @DateVal datetime;

    set dateformat mdy;

    set @DateVal = '2013-02-14T00:00:00';

    select @DateVal;

    go

    declare @DateVal datetime;

    set dateformat dmy;

    set @DateVal = '2013-02-14T00:00:00';

    select @DateVal;

    go

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.