Setting a session's timestamp

To record a session's time information, you have to set its timestamp. Oracle DataServer enables you to select the timestamp using the -Dsrv connection parameter switch, SESSION:TIME-SOURCE.

The following table describes the SESSION:TIME-SOURCE switch:

Table 1. SESSION:TIME-SOURCE
Switch Description
SYS  
Specifies the system timestamp for the session
DB             
Specifies the database timestamp for the session
UTC
Specifies the UTC timestamp for the session
[TZH:TZM]         
Specifies the timezone timestamp for the session

The following code would set the system timestamp for a session using the -Dsrv connection parameter:

-Dsrv session-timezone,SYS

The following example would set the timezone timestamp for the session using the -Dsrv connection parameter to +5:30:

-Dsrv session-timezone,+5:30