In MySQL, the DATE_FORMAT() function allows you to format the date and time. Here's an example: SELECT DATE_FORMAT(''. This page shows you the most commonly used MySQL Date Functions that allow you to manipulate date and time data effectively. MySQL Functions and Usage. The DATE_FORMAT() function formats a date as specified. %r, Time in 12 hour AM or PM format (hh:mm:ss AM/PM). The DATE type is used when you need only a date value, without a time part. MySQL retrieves and displays DATE values in 'YYYY-MM-DD' format. In this page we are going to discuss about MySql date and time functions. Some date and time functions have described in this page. MySQL Date and Time Functions - Learn MySQL from basic to advanced covering database programming clauses command functions administration queries. This section describes the functions that can be used to manipulate temporal values. See Section , “Date and Time Types”, for a description of the range of . Parameter, Description. expression, Required. A valid date/datetime value. Returns NULL if expression is not a date or a datetime. The following table lists the most important built-in date functions in SQL Server: MySQL comes with the following data types for storing a date or a date/time. MySQL Server Time Zone Support. This section describes the time zone. See Section , “Date and Time Types ”, for a description of the range of.