PostgreSQL_CE
PGCES-02 · Question #122
The present time is noon of July 7th, 2007, and the result of the following SQL sentence was '2007-07-17 12:00:00'. Select the correct expression to fill in the blank below. SELECT…
The correct answer is B. '10 day'::interval. See the full explanation below for the reasoning.
Question
The present time is noon of July 7th, 2007, and the result of the following SQL sentence was '2007-07-17 12:00:00'. Select the correct expression to fill in the blank below. SELECT CURRENT_TIMESTAMP::timestamp + ________________ ;
Options
- A'10 day'::timestamp
- B'10 day'::interval
- C10::day
- D8640000::time
- Eage(8640000)
How the community answered
(25 responses)- A8% (2)
- B84% (21)
- D4% (1)
- E4% (1)
Community Discussion
No community discussion yet for this question.