Multiple choice technology mainframe

For date and time stamp queries if the value is null then what is returned for low-date and low-timestamp

  1. (0000-00-00 and 0000-00-00-00.00.00.000000)

  2. (0001-01-01 and 0001-01-01-01.01.01.000001)

  3. (0001-01-01 and 0001-01-01-00.00.00.000000)

  4. (0001-01-01 and 0000-00-00-00.00.00.000000)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In DB2 database systems, when date or timestamp columns have null values, their low-value (minimum) default representations are '0001-01-01' for dates and '0001-01-01-00.00.00.000000' for timestamps. All-zero values are invalid in DB2, and other choices specify incorrect time components.

Keep practicing — related questions