Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

PostgreSQL Exam PGCES-02 Topic 10 Question 46 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 46
Topic #: 10
[All PGCES-02 Questions]

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

Show Suggested Answer Hide 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
Mary
10 days ago
Wait, are we sure it's not option E? I mean, age(8640000) sounds like it might work, right? *scratches head* Oh well, B it is!
upvoted 0 times
...
Leigha
12 days ago
B is the way to go! '10 day'::interval is the only option that makes sense for adding a 10-day period to the current timestamp.
upvoted 0 times
...
Lonna
17 days ago
I'm going to have to go with option D - 8640000::time. I mean, who doesn't love a good time-based solution, right? *chuckles*
upvoted 0 times
...
Holley
18 days ago
Option B is the correct answer, for sure. It's the only one that actually uses an interval to add 10 days to the current timestamp.
upvoted 0 times
Maryanne
1 days ago
I think option B is the correct answer.
upvoted 0 times
...
...
Marge
1 months ago
Hmm, this looks like a tricky one. I'm going to go with option B - '10 day'::interval. That seems like the most logical way to add a 10-day interval to the current timestamp.
upvoted 0 times
...
Melinda
2 months ago
I'm not sure, but I think option A) '10 day'::timestamp could also be a valid answer.
upvoted 0 times
...
Gladys
2 months ago
I agree with Bernardine, because we need to add an interval of 10 days to the current timestamp.
upvoted 0 times
...
Bernardine
2 months ago
I think the correct answer is B) '10 day'::interval.
upvoted 0 times
...

Save Cancel