7.31. ODPI-C Structure dpiTimestamp

This structure is used for passing timestamp data to and from the database in the structure dpiData.

int16_t dpiTimestamp.year

Specifies the year for the timestamp.

uint8_t dpiTimestamp.month

Specifies the month for the timestamp. This should be between 1 and 12.

uint8_t dpiTimestamp.day

Specifies the day for the timestamp. This should be between 1 and 31.

uint8_t dpiTimestamp.hour

Specifies the hour for the timestamp. This should be between 0 and 23.

uint8_t dpiTimestamp.minute

Specifies the minute for the timestamp. This should be between 0 and 59.

uint8_t dpiTimestamp.second

Specifies the second for the timestamp. This should be between 0 and 59.

uint32_t dpiTimestamp.fsecond

Specifies the fractional seconds for the timestamp, in nanoseconds.

int8_t dpiTimestamp.tzHourOffset

Specifies the hours offset from UTC. This value is only used for timestamp with time zone and timestamp with local time zone columns.

int8_t dpiTimestamp.tzMinuteOffset

Specifies the minutes offset from UTC. This value is only used for timestamp with time zone and timestamp with local time zone columns. Note that this value will be negative in the western hemisphere. For example, when the timezone is -03:30, tzHourOffset will be -3 and tzMinuteOffset will be -30.