Github user dongjoon-hyun commented on the issue:
https://github.com/apache/spark/pull/14778
Ur, @HyukjinKwon .
If you compare this with `MySQL` which returns timestamp for timestamp
input, e.g., `date_add(current_timestamp(), INTERVAL 1 DAY)`, this might look
weird. But, currently, this follows `Hive` definition and behavior. According
to the current definition, these functions already define their input and
output as `start_date` and `date` which means the `day` part of a certain time.
For example, we usually don't say `current_date()` function ignores the time
part. Sorry, but I'm not sure about this PR.
```
hive> select date_add(current_timestamp, 1);
OK
2016-08-24
Time taken: 0.077 seconds, Fetched: 1 row(s)
hive> describe function date_add;
OK
date_add(start_date, num_days) - Returns the date that is num_days after
start_date.
Time taken: 0.039 seconds, Fetched: 1 row(s)
```
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
