2.2.43 Operands related to date and time

235) pd_leap_second = Y | N
Specifies whether leap seconds are to be applied in time data, timestamp data, and date/time formats.
Y:
  • For time data or timestamp data
    Applies leap seconds in embedded variables and ? parameter values, as well as in values that represent them in character strings.
  • For date/time formats
    Applies leap seconds in values for seconds.
N:
Does not apply leap seconds.
Note
When time data or timestamp data that includes leap seconds is stored in a database, specifying N in this operand might result in an error when time operations are performed using time data or timestamp data that includes leap seconds. If this occurs, you can use the SECOND scalar function to extract the leap seconds.