CURRENT_TIMESTAMP 를 호출하면된다.

SELECT CURRENT_TIMESTAMP AS current_date_time;

-----------------------
2019-02-23 20:02:21.550

(1 row affected)

참고 자료

https://www.sqlservertutorial.net/sql-server-date-functions/sql-server-current_time-function/