Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-209

CURRENT_DATE Keyword on MS SQL Server

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Cannot Reproduce
    • 1.7.07
    • None
    • CRC Cell
    • 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 )



      Attachments

        Activity

          People

            mem61 Mike Mendis
            tobiasgrossmann Tobias Grossmann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: