Which of the following are the DATETIME data types that can be used in column definitions?

Category: SQLWhich of the following are the DATETIME data types that can be used in column definitions?
Editor">Editor Staff asked 2 years ago

Which of the following are the DATETIME data types that can be used in column definitions?

  1. TIMESTAMP
  2. INTERVAL MONTH TO DAY
  3. INTERVAL YEAR TO MONTH
  4. TIMESTAMP WITH DATABASE TIMEZONE
1 Answers
Editor">Editor Staff answered 2 years ago

Answer: 1,3
Explanation:
Options A and C are correct. It is because they are the DATETIME data types that can be used to specify column definitions.
Option B cannot be used to specify the column definitions because there are only INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH data types.
Option D cannot be used to specify the column definitions because there are only TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE data types.