Andy

    Andy

    1 month ago
    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

    1 month ago
    Hello Andy
    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
    Bolek Ziobrowski

    Bolek Ziobrowski

    1 month ago
    @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

    1 month ago
    @Bolek Ziobrowski Yeah,thank you, I copy it to word a few days ago and then paste back !
    Bolek Ziobrowski

    Bolek Ziobrowski

    1 month ago
    So does it work when typed from scratch ?
    Andy

    Andy

    1 month ago
    yeah! no error report
    Bolek Ziobrowski

    Bolek Ziobrowski

    1 month ago
    cool
    Andy

    Andy

    1 month ago
    👍🙏