3 Replies Latest reply: Oct 10, 2018 9:01 PM by Bala Bhaskar RSS

    SELECT from SQL Database issue

    Zhitao Gao

      Hi,

       

      i'm having trouble using DataManager loading data from a database.

       

       

      I already connected my APP with database and try to get some rows in the table.

       

      There is a colum 'FILLINDATE' in this table. And I want to apply a filter before loading from the table, so I dont have to load all data from the table. This colum has the format" 01/01/2016 00:00:00 AM"

       

      As my understanding, applying this filter equals adding the read "Where FILLINDATE>='2018'" below.

       

      Select

           xxx

           xxx

           xxx

       

      FROM xxx Where FILLINDATE>='2018'


      I tried several SQL such as CONVERT(), or Date but none of these works.

      Thanks for any tips.