Special Variables

$HOROLOG
$JOB
$NAMESPACE
$TLEVEL
$USERNAME
$ZHOROLOG
$ZJOB
$ZPI
$ZTIMESTAMP
$ZTIMEZONE
$ZVERSION

InterSystems SQL directly supports a number of the ObjectScript special variables. These variables contain system-supplied values. They can be used wherever a literal value can be specified in InterSystems SQL.

Variable Name	Abbreviation	Data Type Returned	Use
$HOROLOG	$H	%String/VARCHAR	Local date and time for the current process
$JOB	$J	%String/VARCHAR	Job ID of the current process
$NAMESPACE	none	%String/VARCHAR	Current namespace name
$TLEVEL	$TL	%Integer/INTEGER	Current transaction nesting level
$USERNAME	none	%String/VARCHAR	User name for the current process
$ZHOROLOG	$ZH	%Numeric/NUMERIC(21,6)	Number of elapsed seconds since InterSystems IRIS startup
$ZJOB	$ZJ	%Integer/INTEGER	Job status for the current process
$ZPI	none	%Numeric/NUMERIC(21,18)	The numeric constant PI
$ZTIMESTAMP	$ZTS	%String/VARCHAR	Current date and time in Coordinated Universal Time format
$ZTIMEZONE	$ZTZ	%Integer/INTEGER	Local time zone offset from GMT
$ZVERSION	$ZV	%String/VARCHAR	The current version of InterSystems IRIS

SELECT TOP 5 Name,$H
FROM Sample.Person

SELECT TOP 5 Name,Home_State
FROM Sample.Person
WHERE $ZTIMEZONE BETWEEN 300 AND 480