DATE()

Description

Extracts the date part of the date or datetime expression expr.

Syntax

  1. > DATE(expr)

Arguments

ArgumentsDescription
exprRequired. The date/datetime to extract the date from.

Examples

  1. drop table if exists t1;
  2. create table t1(a date, b datetime);
  3. insert into t1 values('2022-01-01','2022-01-01 01:01:01');
  4. insert into t1 values('2022-01-01','2022-01-01 01:01:01');
  5. insert into t1 values(20220101,'2022-01-01 01:01:01');
  6. insert into t1 values('2022-01-02','2022-01-02 23:01:01');
  7. insert into t1 values('2021-12-31','2021-12-30 23:59:59');
  8. insert into t1 values('2022-06-30','2021-12-30 23:59:59');
  10. mysql> select date(a),date(b) from t1;
  11. +------------+------------+
  12. | date(a)    | date(b)    |
  13. +------------+------------+
  14. | 2022-01-01 | 2022-01-01 |
  15. | 2022-01-01 | 2022-01-01 |
  16. | 2022-01-01 | 2022-01-01 |
  17. | 2022-01-02 | 2022-01-02 |
  18. | 2021-12-31 | 2021-12-30 |
  19. | 2022-06-30 | 2021-12-30 |
  20. +------------+------------+
  21. 5 rows in set (0.01 sec)
  23. mysql> select date(a),date(date(a)) as dda from t1;
  24. +------------+------------+
  25. | date(a)    | dda        |
  26. +------------+------------+
  27. | 2022-01-01 | 2022-01-01 |
  28. | 2022-01-01 | 2022-01-01 |
  29. | 2022-01-01 | 2022-01-01 |
  30. | 2022-01-02 | 2022-01-02 |
  31. | 2021-12-31 | 2021-12-31 |
  32. | 2022-06-30 | 2022-06-30 |
  33. +------------+------------+
  34. 5 rows in set (0.00 sec)

Constraints

The date type supports only yyyy-mm-dd and yyyymmdd for now.