Table of Contents
Ispirer Website
Ispirer Capabilities - MySQL Migration
Free Trial
MySQL - Date and Time Functions
This article describes date and time functions in MySQL.
Overview
Date and Time Function | Description |
---|---|
DATE() | Extracts date part (day, month and year) |
DATE
MySQL - DATE | |
---|---|
Syntax | DATE(datetime_expression) |
Description | DATE extracts the date part (day, month and year) of the datetime expression |
Return Value | The return type is DATE |
Example:
mysql> SELECT DATE(CURRENT_TIMESTAMP), CURRENT_TIMESTAMP; +-------------------------+----------------------+ | 2009-08-19 | 2009-08-19 12:42:18 | +-------------------------+----------------------+ 1 row in set (0.00 sec)
MySQL DATE - Equivalents in Other Databases
Database | Equivalent |
---|---|
Oracle | TRUNC(date) - truncates date to year, month, and day |