Wei-Ting Kuo

@JasonLi-cn thank you, looks like this is solved in some pr. I'll close this issue as this is similar as #3103 now.

## EDIT: this result is from datafusion-cli v10.0.0; i found that some fails are fixed in master branch; please check following comments @andygrove I created the datafusion branch and submitted...

@andygrove after update datafusion-cli to master version 1-36 passed 37-42 passed but it's incorrect 43 failed the issues from 37-42 are the same ``` 37. SELECT "URL", COUNT(*) AS PageViews...

@andygrove datafusion is added now the pr is to add readme to reproduce the result. I think we can close this now

should be arrow-datafusion 12.0.0?

extract has the same behavior ```bash ❯ select extract(hour from now()); Plan("Coercion from [Utf8, Timestamp(Nanosecond, Some(\"UTC\"))] to the signature OneOf([Exact([Utf8, Date32]), Exact([Utf8, Date64]), Exact([Utf8, Timestamp(Second, None)]), Exact([Utf8, Timestamp(Microsecond, None)]), Exact([Utf8,...

@turbo1912 i'm not working on this yet. It's not fixed yet, we could only cast `Timestamp(Nanosecond, Some(\"UTC\")` to `Timestamp(Nanosecond, None)` for now. I'd be great if you can help ❤️

> > 3. we could think about whether we really need timestamp with time zone - timestamp ... this is what postgresql has > > I don't quite understand the...

> @waitingkuo what do you think about making a list on this ticket of all the various timestamp / time related open items? I think there are a non trivial...

> > it breaks while we have hour > > I believe a Date has the resolution of 24 hours, so adding 1 or 23 hours should have no effect?...