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

Returning the Current Date and Time by using CURRENT_TIMESTAMP

   <source lang="sql">

4> 5> SELECT CURRENT_TIMESTAMP -- Current Date and Time 6> GO

---

2007-10-19 06:28:54.330 (1 rows affected)

</source>