What will be the result of this PostgreSQL query?

medium📝 query result Q5 of 15

PostgreSQL - PL/pgSQL Fundamentals

SELECT NOW()::date;

ATimestamp with time zone

BCurrent time without date

CError due to invalid cast

DCurrent date without time

Step-by-Step Solution

Solution:

Step 1: Understand NOW() function
NOW() returns current timestamp with date and time.
Step 2: Understand casting to date
Using ::date converts timestamp to date only, removing time part.
Final Answer:
Current date without time -> Option D
Quick Check:
NOW()::date returns date only [OK]

Quick Trick: Cast timestamp to date to remove time [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free