Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Special Registers - DB2

RSS
Modified on Tue, Jan 06, 2009, 12:50 PM by Administrator Categorized as DB2
The following special registers apply to the server where the SQL statement containing them is running.

Register Description
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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.