Which function returns the current date and time?

Which function returns the current date and time?

• A. current_date/time
• B. Date_Trunc
• C. age
• D. NOW

Answer: (D)

You’re looking for the function that gives the exact moment right now, including both the date and the time. NOW does exactly that: it returns the current timestamp (often with time zone) representing the present moment. It’s the go-to choice when you need a single value that captures the current date and time. The other options don’t fit as neatly. current_date (or CURRENT_DATE) yields only the date portion, with no time. Date_Trunc requires you to supply a timestamp and then it returns that timestamp rounded down to a specified unit (like the start of the day or hour). age computes the interval between two timestamps or dates, not the current moment. So NOW is the best answer because it directly provides the current date and time in one value. (In many systems, NOW is equivalent to CURRENT_TIMESTAMP.)

You’re looking for the function that gives the exact moment right now, including both the date and the time. NOW does exactly that: it returns the current timestamp (often with time zone) representing the present moment. It’s the go-to choice when you need a single value that captures the current date and time.

The other options don’t fit as neatly. current_date (or CURRENT_DATE) yields only the date portion, with no time. Date_Trunc requires you to supply a timestamp and then it returns that timestamp rounded down to a specified unit (like the start of the day or hour). age computes the interval between two timestamps or dates, not the current moment.

So NOW is the best answer because it directly provides the current date and time in one value. (In many systems, NOW is equivalent to CURRENT_TIMESTAMP.)