DATE()

Description

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

Syntax

1. > DATE(expr)

Arguments

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');
9. > select date(a),date(b) from t1;
10. +------------+------------+
11. | date(a)    | date(b)    |
12. +------------+------------+
13. | 2022-01-01 | 2022-01-01 |
14. | 2022-01-01 | 2022-01-01 |
15. | 2022-01-01 | 2022-01-01 |
16. | 2022-01-02 | 2022-01-02 |
17. | 2021-12-31 | 2021-12-30 |
18. | 2022-06-30 | 2021-12-30 |
19. +------------+------------+
20. > select date(a),date(date(a)) as dda from t1;
21. +------------+------------+
22. | date(a)    | dda        |
23. +------------+------------+
24. | 2022-01-01 | 2022-01-01 |
25. | 2022-01-01 | 2022-01-01 |
26. | 2022-01-01 | 2022-01-01 |
27. | 2022-01-02 | 2022-01-02 |
28. | 2021-12-31 | 2021-12-31 |
29. | 2022-06-30 | 2022-06-30 |
30. +------------+------------+

Constraints

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

Currently, MatrixOne doesn’t support select function() without from tables.