qstommyshu commented on issue #12342:
URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2812968577
Oh I see, thanks @Omega359 for sending the doc.
Hope you don't mind me asking another question. I'm still wondering why we
want DF to support operations like `select t
Omega359 commented on issue #12342:
URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2813000882
Date parsing and date arithmetic is very common in some applications. using
`to_date('1970-01-01') + 5` is just easier than `to_date('1970-01-01') +
INTERVAL 5 days` or somethi
Omega359 commented on issue #12342:
URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2812809389
> Ah, looks like datafusion doesn't even support this `to_date('1970-01-01',
'-mm-dd');` in v46.0.1
Wrong format. See
https://datafusion.apache.org/user-guide/sql/sc
qstommyshu commented on issue #12342:
URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2811368679
Ah, looks like datafusion doesn't even support this `to_date('1970-01-01',
'-mm-dd');` in v46.0.1
```SQL
> select to_date('1970-01-01', '-mm-dd');
Executi
milevin commented on issue #12342:
URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2538336030
I put up a PR, but it's not perfect as I describe in its summary. Would love
to get feedback and suggestions from the experts!
--
This is an automated message from the Apache
milevin commented on issue #12342:
URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2529530860
take
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To un
milevin commented on issue #12342:
URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2529504192
I'll take this one if no one objects.
I'll use Snowflake's semantics as an approximation.
--
This is an automated message from the Apache Git Service.
To respond to the
gnayus commented on issue #12342:
URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2505295586
Using intervals, both of the following work:
select to_date('1970-01-01') + interval '5' day;
select interval '5' day + to_date('1970-01-01');
Do we want to suppor
comphead commented on issue #12342:
URL: https://github.com/apache/datafusion/issues/12342#issuecomment-2332182699
> That is an odd thing for pg to support because the unit for the int is
implied as it could just as well be months or years.
I cannot find the standard right away, but f
