Homework answers / question archive / MySQL has many native functions that will come in handy from time to time

MySQL has many native functions that will come in handy from time to time

Computer Science

Share With

MySQL has many native functions that will come in handy from time to time. One is the current_date() function referenced in the previous chapter. SELECT CURRENT_DATE(); will retrieve the current date in YYYY-MM-DD format, it also provides a column header of current_date(). Instead of having a column header as the function name, you can stipulate what alias you'd like to use. SELECT CURRENT_DATE() AS 'Today's Date'; will return the same result with a column header of Today's Date, which is much more user friendly. The is an escape character so you could use the apostrophe in the column header. If you have only a single word as an alias, you do not need to enclose it in single quotation marks. Click for more options Go out to the W3Schools links above, and select at least three functions to experiment with. For each: Provide an explanation of when it might be used. Provide an appropriate alias for the column header in the results. Provide the SQL statment, run the statement, then take a screenshot of the results.