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?
That's only an issue if the year is mentioned at the end (02-09-2009). When the year is mentioned first it's always yyyy-mm-dd, many times also noted without the dashes (20090902).
Well, that's exactly what I would have expected. Nevertheless, when I copy & pasted the given statement
SELECT DATEADD(MINUTE,30,DATEADD(hour,7,'2009-02-09 10:00:00:000'))
into SS Studio Express and pressed F5, my result was
Rather confuses me... :unsure: