waitingkuo commented on issue #4644:
URL:
https://github.com/apache/arrow-datafusion/issues/4644#issuecomment-1354186515
fyi
this is straightforward
```bash
willy=# select timestamp '2000-01-01T00:00:00.00000' = date '2000-01-01';
?column?
----------
t
(1 row)
```
and there're more to consider for timestamptz (i'm in UTC+8)
```bash
willy=# select timestamptz '2000-01-01T00:00:00.00000+00' = date
'2000-01-01';
?column?
----------
f
(1 row)
```
```bash
willy=# select timestamptz '1999-12-31T16:00:00.00000+00' = date
'2000-01-01';
?column?
----------
t
(1 row)
```
```bash
willy=# select timestamptz '2000-01-01T00:00:00.00000+08' = date
'2000-01-01';
?column?
----------
t
(1 row)
```
--
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 unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
