Title
#users-public
Andy

Andy

08/23/2022, 3:10 AM
these codes ran smoothly serveral days ago , but don't work today : report error unknown function name : timestamp_floor() select code,timestamp_floor('m',timestamp) as timestamp,close/open-1 as r from 'kline_5M' where timestamp
timestamp_floor('d', to_timezone(sysdate(),'Asia/Shanghai'))
and hour(timestamp)>=9 and minute(timestamp)>24
Andrey Pechkurov

Andrey Pechkurov

08/23/2022, 6:33 AM
Hello Andy
6:33 AM
This looks a lot like a bug. Could you create a GH issue with a minimal reproducer?https://github.com/questdb/questdb/issues/new?assignees=&labels=bug&template=bug_report.yaml
6:34 AM
Bolek Ziobrowski

Bolek Ziobrowski

08/23/2022, 7:17 AM
@Andy There could be invisible characters in where clause so it'd be good if you re-typed it from scratch (don't copy & paste) and ran again . I ran it on a sample table and it was fine .
Andy

Andy

08/23/2022, 7:21 AM
@Bolek Ziobrowski Yeah,thank you, I copy it to word a few days ago and then paste back !
Bolek Ziobrowski

Bolek Ziobrowski

08/23/2022, 7:21 AM
So does it work when typed from scratch ?
Andy

Andy

08/23/2022, 7:22 AM
yeah! no error report
Bolek Ziobrowski

Bolek Ziobrowski

08/23/2022, 7:22 AM
cool
Andy

Andy

08/23/2022, 7:22 AM
👍🙏