Multiple choice technology databases

what is true about function now();

  1. Returns current system date and time.

  2. Returns only current time

  3. Returns only current date.

  4. There is no function like now();

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The NOW() function in SQL returns the current system date and time together. It does not return date or time separately - those would be CURDATE() and CURTIME() respectively. The function exists in all major SQL databases.