The SECOND function returns the seconds part of a value with optional fractional seconds.

The schema is SYSIBM.

expression

An expression that returns a value of one of the following built-in data types:
DATE, TIME, TIMESTAMP, time duration, timestamp duration, or a valid character string representation of a date, time, or timestamp that is not a CLOB.
If expression is a DATE or a valid string representation of a date, it is first converted to a TIMESTAMP(0) value, assuming a time of exactly midnight (00.00.00).
If expression is a valid string representation of a timestamp, it is first converted to a TIMESTAMP(12) value.
In a Unicode database, if a supplied argument is a graphic string, it is first converted to a character string before the function is executed.

integer-constant

An integer constant representing the scale for the fractional seconds.
The value must be in the range 0 through 12.

The result of the function with a single argument is a large integer.
The result of the function with two arguments is DECIMAL(2+s,s) where s is the value of the integer-constant.
If the first argument can be null, the result can be null; if the first argument is null, the result is the null value.

The other rules depend on the data type of the first argument and the number of arguments:

• If the first argument is a DATE, TIME, TIMESTAMP, or valid string representation of a date, time, or timestamp:
  • If only one argument is specified, the result is the seconds part of the value (0 and 59).
  • If both arguments are specified, the result is the seconds part of the value (0 to 59) and integer-constant digits of the fractional seconds part of the value where applicable.
    If there are no fractional seconds in the value, then zeros are returned.


• If the first argument is a time duration or timestamp duration:
  • If only one argument is specified, the result is the seconds part of the value (-99 to 99).
  • If both arguments are specified, the result is the seconds part of the value (-99 to 99) and integer-constant digits of the fractional seconds part of the value where applicable.
    If there are no fractional seconds in the value then zeros are returned.
    A nonzero result has the same sign as the argument.

Examples

1. Assume that the host variable TIME_DUR (decimal(6,0)) has the value 153045.

       SELECT SECOND(:TIME_DUR)
       FROM   SYSIBM.SYSDUMMY1

   Returns the value 45.

2. Assume that the column RECEIVED (whose data type is TIMESTAMP) has an internal value equivalent to 1988-12-25-17.12.30.000000.

       SELECT SECOND(RECEIVED)
       FROM   IN_TRAY

   Returns the value 30.

3. Get the seconds with fractional seconds from a current timestamp with milliseconds.

       SELECT SECOND (CURRENTTIMESTAMP(3), 3)
       FROM   SYSIBM.SYSDUMMY1

   Returns a DECIMAL(5,3) value based on the current timestamp that could be something like 54.321.