Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

Select 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)