CURDATETIME
Returns the current date and time, corrected for the server's time zone (except for the database server).
Note: This function is equivalent to dbo.GetSiteDate(getdate()) in T-SQL. 
      Return Value
Date/Time
Syntax
CURDATETIME( )
         
Returns the current date and time, corrected for the server's time zone (except for the database server).
Date/Time
CURDATETIME( )