2 Replies Latest reply: Jan 29, 2013 8:43 AM by Davide Ducco RSS

    SQL where to_date()

    Davide Ducco

      Hi,

      I have a problem on a data loading.

      I want to filter the data during loading step with a date filter, for example:

      SQL Select *

      from db

      where DateDB > TO_DATE('01012013','DDMMYYYY');

       

      The script does not show any error but it does not extract any record (but record with those dates are present in db).

      Database is SQL Server db.

       

      Anyone can help me?

      Many thanks in advance.

      Davide