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. 0001-01-01 and 0000-00-00-00.00.00.000000

  2. 0001-01-01 and 0001-01-01-01.01.01.000001

  3. 0000-00-00 and 0000-00-00-00.00.00.000000

  4. 0001-01-01 and 0001-01-01-00.00.00.000000
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

For null date/timestamp values in certain legacy systems, low-date returns 0001-01-01 and low-timestamp returns 0001-01-01-00.00.00.000000 as minimum default values.

Keep practicing — related questions