Multiple choice technology mainframe

Select query for a date field should be

  1. SELECT CHAR(CAST (tablename.Date_variable AS DATE), ISO

  2. SELECT DATE(tablename.Date_variable, ISO)

  3. SELECT (tablename.Date_variable AS DATE)

  4. ALL OF THEM
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The correct syntax uses CAST to convert the date variable to DATE format, then CHAR to format it with ISO standard. Options B and C use incorrect syntax, and D cannot be correct since only A follows proper SQL date casting conventions.

Keep practicing — related questions