10.3.8 Operands related to date and time

17) pd_leap_second = Y | N
Operand default value
  • Default value in recommended mode: Y
  • Default value in 0904 compatibility mode: 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
If 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.