PostgreSQL Exam PGCES-02 Topic 10 Question 46 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 46
Topic #: 10

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 + ________________ ;

A'10 day'::timestamp

B'10 day'::interval

C10::day

D8640000::time

Eage(8640000)

Show Suggested Answer

Suggested Answer: A

by Myra at Jul 25, 2023, 02:51 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Melinda

10 days ago

I'm not sure, but I think option A) '10 day'::timestamp could also be a valid answer.

upvoted 0 times

...

Gladys

19 days ago

I agree with Bernardine, because we need to add an interval of 10 days to the current timestamp.

upvoted 0 times

...

Bernardine

20 days ago

I think the correct answer is B) '10 day'::interval.

upvoted 0 times

...