SQL functions return information about some aspect of the database, depending on the arguments specified at the time the function is invoked.
Functions provide a single result by accepting input arguments and returning an output value. Some SQL functions, referred to as niladic functions, do not have arguments, but they do return values. An example of a niladic SQL function is CURRENT_DATE.