odbtools/odbctest/mql/uino/071.sql.mql

-- SELECT dynamic_card.id AS 'id', dynamic_card.name AS 'name', dynamic_card.asker AS 'asker', dynamic_card.createtimestamp AS 'createtimestamp' FROM /test_monitor/dynamic_card_monitor dynamic_card WHERE dynamic_card.createtimestamp > '2026-01-21 00:00:00' and dynamic_card.createtimestamp < '2026-01-21 20:00:00' AND dynamic_card.name like '%精品%' LIMIT 0, 500000
-- /**
-- timeout(60m)
-- output()
-- outputcount()
-- count(30)
-- **/
-- ;


-- SELECT dynamic_card.id AS 'id', dynamic_card.name AS 'name', dynamic_card.asker AS 'asker', dynamic_card.createtimestamp AS 'createtimestamp' FROM /test_monitor/dynamic_card_monitor dynamic_card WHERE dynamic_card.createtimestamp > '2026-01-21T00:00:00' and dynamic_card.createtimestamp < '2026-01-21 20:00:00' AND dynamic_card.name like '%精品%' LIMIT 0, 500000
-- /**
-- timeout(60m)
-- output()
-- outputcount()
-- count(30)
-- **/
-- ;


-- -- sqlite 支持的时间格式 YYYY-mm-dd HH:MM:ss.SSS, 不支持由 ODBServer 转换后的输出格式 2016-01-02T15:04:05.000-07:00
-- {"sql":"SELECT dynamic_card.id AS 'id', dynamic_card.name AS 'name', dynamic_card.asker AS 'asker', dynamic_card.createtimestamp AS 'createtimestamp' FROM /test_monitor/dynamic_card_monitor dynamic_card WHERE dynamic_card.createtimestamp > '2026-01-21 00:00:00' AND dynamic_card.name like '%精品%' LIMIT 0, 500000"}
-- /**
-- timeout(60m)
-- xoutput()
-- outputcount()
-- count(30)
-- **/
-- ;


{"sql":"select strftime('%Y-%m-%dT%H:%M:%S.%f',1111111111.111,'unixepoch') as createtimestamp from /test_monitor/dynamic_card_monitor where name like '%精品%'"}
-- {"sql":"select strftime('%Y-%m-%dT%H:%M:%S.%f',createtimestamp) as createtimestamp from /test_monitor/dynamic_card_monitor where name like '%精品%'"}
/**
timeout(60m)
output()
**/
;