select CURRENT_TIMESTAMP : CURRENT_TIMESTAMP « Date Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Date Functions
3. CURRENT_TIMESTAMP

10> SELECT CURRENT_TIMESTAMP, USER, SYSTEM_USER, CURRENT_USER,
11> SESSION_USER
12> GO



----------------------- -------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------
--------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------
---------- --------------------------------------------------------------------------------------------------------------------------------
2008-08-17 13:20:57.503 dbo                                                                                                                              J\Administrator
                                                                                  dbo
           dbo

(1 rows affected)