The FORMAT() function is used to format how a field is to be displayed.
We have the following "Products" table:
Now we want to display the products and prices per today's date (with today's date displayed in
the following format "YYYY-MM-DD").
We use the following SELECT statement:
The result-set will look like this:
Your Query was successfully sent!