DATE_ADD truncates time

[bheni]

In dolt I get:

SELECT NOW(), DATE_ADD(NOW(), INTERVAL 14 DAY);
+----------------------------+----------------------------------+
| NOW()                      | DATE_ADD(NOW(), INTERVAL 14 DAY) |
+----------------------------+----------------------------------+
| 2022-09-20 13:23:05.020674 | 2022-10-04                       |
+----------------------------+----------------------------------+

In mysql you get this:

+----------------------------+----------------------------------+
| NOW()                      | DATE_ADD(NOW(), INTERVAL 14 DAY) |
+----------------------------+----------------------------------+
| 2022-09-20 13:24:06        | 2022-10-04 13:24:06              |
+----------------------------+----------------------------------+