Date Timezone MSSQL

3> select MONTH('2002-09-30')
4> GO
-----------
          9
(1 rows affected)
1>