CURRENT SERVER | the name of the server |
CURRENT TIME | the time from the system clock. Multiple uses of this register within the same SQL statement yield identical results |
CURRENT TIMESTAMP | a timestamp based on the system clock |
CURRENT TIMEZONE | the difference between UTC (Universal Time, Coordinated a.k.a. zulu, Greenwich Mean Time, and GMT) and the local server time, between -24 hours and +24 hours as a DECIMAL(6,0). Subtracting CURRENT TIMEZONE from a local time converts it to UTC. |
CURRENT DATE | the date from the system clock |
USER | the username under which the SQL statment is running |