OracleTimeStampTZ(int, int, int, int, int, int, double, string)

This constructor creates a new instance of the OracleTimeStampTZ structure and sets its value for date and time using year, month, day, hour, minute, second, millisecond, and time zone data.

Declaration

// C#
public OracleTimeStampTZ(int year, int month, int day, int hour, 
  int minute,   int second, double millisecond, string timeZone);

Parameters

year

The year provided. Range of year is (-4712 to 9999).
month

The month provided. Range of month is (1 to 12).
day

The day provided. Range of day is (1 to 31).
hour

The hour provided. Range of hour is (0 to 23).
minute

The minute provided. Range of minute is (0 to 59).
second

The second provided. Range of second is (0 to 59).
millisecond

The millisecond provided. Range of millisecond is (0 to 999.999999).
timeZone

The time zone data provided.

Exceptions

ArgumentOutOfRangeException - The argument value for one or more of the parameters is out of the specified range.

ArgumentException - The argument values of the parameters cannot be used to construct a valid OracleTimeStampTZ (that is, the day is out of range for the month or the time zone is invalid).

Remarks

timeZone can be either an hour offset, for example, 7:00, or a valid time zone region name that is provided in V$TIMEZONE_NAMES, such as US/Pacific. Time zone abbreviations are not supported.

If time zone is null, the OracleGlobalization.TimeZone of the thread is used.

Note:

PST is a time zone region name as well as a time zone abbreviation; therefore it is accepted by OracleTimeStampTZ.