• Stewart "Arturius" Campbell - Thursday, November 8, 2018 10:53 PM

    Really interesting question, thanks Steve

    forgot that  the results of this datetime function is non-deterministic....

    DATEPART not always is nondeterministic.
    e.g. datepart(day,'20180131') is deterministic because it returns always 31
    e.g. datepart(dw,'20180131') is NONdeterministic, because it depends from localization.