OracleTimeStampTZ(int, int, int, string)

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

Declaration

// C#
public OracleTimeStampTZ(int year, int month, int day, 
  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).

  • 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.