odbtools/odbctest/mql/uino/103.between语句查询.mql

-- match (project:/mingdao1/project WHERE attr45 between '2024-01-01' AND '2024-12-31' AND attr40 like '*已完成*' )<-[:is_case_of_project*1..1]-(case:/mingdao1/case WHERE attr8 = '*效果*' OR attr9 = '*效果*') return project.id
-- /**
-- output()
-- **/
-- ;


-- match (contract:/mingdao1/contract )-[:is_contract_of_project*1..1]->(project:/mingdao1/project WHERE attr45 between '2024-01-01' AND '2024-12-31' AND attr40 like '*已完成*' )<-[:is_case_of_project*1..1]-(case:/mingdao1/case WHERE attr8 = '*效果*' OR attr9 = '*效果*') return project.id
-- /**
-- output()
-- **/
-- ;

-- select id,attr4 from /mingdao1/project WHERE attr4 between '2023-01-01' AND '2023-06-30'

-- MATCH 
--       (contract:/mingdao1/contract)-[:is_contract_of_project*1..1]->(project:/mingdao1/project WHERE attr4 between '2023-01-01' AND '2023-06-30')
-- /**
-- output()
-- **/
-- ;

select * from /dsq_stock/doc_research_report_core where doctime between '2025-05-01 00:00:00' and '2025-05-31 00:00:00'
/**
output()
**/
;