SQL Server/T-SQL/Date Timezone/CURRENT TIMESTAMP

Returning the Current Date and Time by using CURRENT_TIMESTAMP

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