• Mike John (3/4/2009)


    Alternative answer is :

    2009-09-02 17:30:00.000 -- which is exactly what you will see if you are configured for a UK date format. ie the dateadds behave as described by the input date is in an ambiguous format... was it the 2nd Sept or 9th Feb?

    Mike John

    is always YYYY-MM-DD when written this way. 🙂

    Hiding under a desk from SSIS Implemenation Work :crazy: