Hello. I need help with DB data input. Among the fields of the mariadb table, the field related to time is divided into two. Both fields are of type varchar. 1) The date field stores today's date. ex) 2022215 2) The time field stores the time. Leading zeros are omitted. ex) 110203000 (hhmmssSSS) For time fields, leading zeros are omitted. In the case of 00:02:03, it becomes as follows. ex) 203000 As a side note, I know these configurations aren't common, I didn't create them. In the above situation, to get data through the rising column, the query is structured as follows. select concat(date,lpad(time,'9','0')) as time from ~~~ where time > 1 If i execute a query on the db connect setting screen, data is imported normally. However, once the setup is complete and the query is run on a schedule, the data will not be indexed. In db connect, if data is artificially processed through a query, can't I get data? thank you.
... View more