You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "itxiangkui (Jira)" <ji...@apache.org> on 2022/03/14 03:17:00 UTC

[jira] [Created] (CALCITE-5039) View:Timestamp cannot query Data:Long in GMT+8 TimeZone Env

itxiangkui created CALCITE-5039:
-----------------------------------

             Summary: View:Timestamp cannot query Data:Long in GMT+8 TimeZone Env
                 Key: CALCITE-5039
                 URL: https://issues.apache.org/jira/browse/CALCITE-5039
             Project: Calcite
          Issue Type: Bug
          Components: jdbc-driver
    Affects Versions: 1.29.0
            Reporter: itxiangkui


When I have a row like :
|ts:TimeStamp|channel:String|pv:Long|
|1647187200000|ios|10|

 

while 1647187200000 is a timestamp in TimeZone of "GMT+8",the datetime is "2022-03-14 00:00:00"

but you can not query the data using a sql like :

```sql

select * from table where ts='2022-03-14 00:00:00';

select * from table where ts<'2022-03-14 00:00:01' and  ts>'2022-03-13 23:59:59' ;

```

it is like the jdbc-fether will filter the data when match the timestampString,while the timestamp String looks like '2022-03-13 16:00:00' or '2022-03-14 08:00:00'

 

 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)