matthewmturner commented on issue #14536:
URL: https://github.com/apache/datafusion/issues/14536#issuecomment-2651906876
@Omega359 totally understood and appreciate the alternatives :)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to
alamb commented on issue #14536:
URL: https://github.com/apache/datafusion/issues/14536#issuecomment-2651879574
I agree -- fixing this issue seems reasonable to me. Thanks @Omega359
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to Gi
Omega359 commented on issue #14536:
URL: https://github.com/apache/datafusion/issues/14536#issuecomment-2648671927
> I had the impression (although perhaps it is dated) that datafusion sought
to be compatible with postgres to the extent reasonable. Assuming thats still
the case is there a r
matthewmturner commented on issue #14536:
URL: https://github.com/apache/datafusion/issues/14536#issuecomment-2646783166
I had the impression (although perhaps it is dated) that datafusion sought
to be compatible with postgres to the extent reasonable. Assuming thats still
the case is ther
xudong963 commented on issue #14536:
URL: https://github.com/apache/datafusion/issues/14536#issuecomment-2646775055
> [@xudong963](https://github.com/xudong963) maybe we should make the error
message better?
Yes, this is a good point
--
This is an automated message from the Apache
alamb commented on issue #14536:
URL: https://github.com/apache/datafusion/issues/14536#issuecomment-2643690203
@xudong963 maybe we should make the error message better?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use
Omega359 commented on issue #14536:
URL: https://github.com/apache/datafusion/issues/14536#issuecomment-2642764287
If you cast the date to a timestamp that would work, but the syntax you
provided would not match a date and thus it'll throw the format error. Any of
the following would work:
xudong963 commented on issue #14536:
URL: https://github.com/apache/datafusion/issues/14536#issuecomment-2642509561
FYI, Postgres supports this, so I think it's a feature.
**Schema (PostgreSQL v17)**
---
SELECT TO_CHAR('2023-09-04'::date, '-MM-DD"T
xudong963 opened a new issue, #14536:
URL: https://github.com/apache/datafusion/issues/14536
It seems that we don't support
```
> select to_char('2023-09-04'::date, '%Y-%m-%dT%H:%M:%S%.3f');
Execution error: Cast error: Format error
```
I want to ensure if this is an unsupport
