Which function returns the current date or current time?

Which function returns the current date or current time?

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

Answer: (A)

The idea being tested is how to obtain the current date or the current time in SQL. A shorthand option like current_date/time directly expresses getting the present date or the present time, so it matches the request most closely. It encapsulates the idea of retrieving either component without specifying a concrete value. The other choices behave differently: NOW (or CURRENT_TIMESTAMP) yields the exact current moment as a full timestamp (date and time together); make_date or make_time are constructors that build a date or a time from given parts, not the current moment; Date_Trunc takes an existing timestamp and rounds it to a specified precision, which is a transformation rather than retrieving the current value.

The idea being tested is how to obtain the current date or the current time in SQL. A shorthand option like current_date/time directly expresses getting the present date or the present time, so it matches the request most closely. It encapsulates the idea of retrieving either component without specifying a concrete value. The other choices behave differently: NOW (or CURRENT_TIMESTAMP) yields the exact current moment as a full timestamp (date and time together); make_date or make_time are constructors that build a date or a time from given parts, not the current moment; Date_Trunc takes an existing timestamp and rounds it to a specified precision, which is a transformation rather than retrieving the current value.