Date Timezone MSSQL

4>
5> SELECT CURRENT_TIMESTAMP -- Current Date and Time
6> GO
-----------------------
2007-10-19 06:28:54.330
(1 rows affected)