Date and Time formatting in MySQL

Most developers familiar with SQL Server have employed the easy to use CAST or CONVERT commands in order to properly format a date. Here's a simple example of CONVERT helping us get a value in the format of MM/DD/YYYY.

This is a great command and it's very easy to use - but do you know how to format date and time values in a similar fashion when coding against a MySQL database? You can use the DATE_FORMAT command and here's how...

This can prove useful when supplying date values for use in a cfgrid via a cfquery returned via a cfc. For more info on building custom date formats with MySQL you can check out MySQL Docs Online.