Details
-
Bug
-
Status: Closed
-
Blocker
-
Resolution: Cannot Reproduce
-
1.7.07
-
None
-
None
-
Rank:0|i002tj:
-
Analysis View
-
i2b2 Core
Description
The SQL Keyword "CURRENT_DATE" is not a function on MSSQL Server. Use GETDATE() function instead.
currently wrongly used:
function: analyses timeline
Log:
[INFO] Using datasource java:/QueryToolDemoDS
select p.patient_num from i2b2demodata.patient_dimension p where p.patient_num IN (select patient_num from i2b2demodata.patient_dimension where birth_date > (CURRENT_DATE - INTERVAL '3653.5 day'))
group by p.patient_num )
currently wrongly used:
function: analyses timeline
Log:
[INFO] Using datasource java:/QueryToolDemoDS
select p.patient_num from i2b2demodata.patient_dimension p where p.patient_num IN (select patient_num from i2b2demodata.patient_dimension where birth_date > (CURRENT_DATE - INTERVAL '3653.5 day'))
group by p.patient_num )