Betternan opened a new issue, #10457:
URL: https://github.com/apache/pinot/issues/10457
When querying the following psql, it comes out two different results:
```
select
cst,
cstdays,
cstms,
DATETIMECONVERT(cstdays, '1:DAYS:EPOCH',
'1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd tz(America/Adak)', '1:DAYS') as dateconv1,
DATETIMECONVERT(cstdays, '1:DAYS:EPOCH',
'1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd tz(-09:00)', '1:DAYS') as dateconv2
from t1
where cstms >= fromDateTime('2023-02-20 09:00:00.000', 'yyyy-MM-dd
HH:mm:ss.SSS')
AND cstms <= fromDateTime('2023-03-22 08:59:59.000', 'yyyy-MM-dd
HH:mm:ss.SSS')
ORDER BY cst DESC
limit 1000
```
**Data Format Example:**
cst: 2023-03-22T05:50:03.437Z
cstdays: 19438
cstms: 1679464203437
**Query Result:**
cst | cstdays | cstms | dateconv1 | dateconv2
2023-03-22T05:50:03.437Z | 19438 | 1679464203437 | 2023-03-21 | 2023-03-22
2023-03-22T05:50:03.408Z | 19438 | 1679464203408 | 2023-03-21 | 2023-03-22
My question is, "America/Adak" has the same meaning with "-09:00", but in
the DATETIMECONVERT function, it returned two different results. So can you
please help point out how to use time offset with this function? Thanks in
advance.
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
