5 Replies Latest reply on Jan 12, 2015 1:14 PM by Steven Hawkins

    Date formats supported in the Data type Transforms

    Shiveeta Mattoo Newbie

      Hi,

       

      While reading DATE/TIME/TIMESTAMP data from file, we encounter these data types in multiple formats.

      However Teiid seems to accept only fixed formats for Date, Time and TimeStamp ( i.e. yyyy-mm-dd, HH:mm:ss, yyyy-mm-dd HH:mm:ss respectively).

      I notice these patterns hardcoded in StringToDateTransform, StringToTimeTransform, and StringToTimestampTransform (teiid-common-core).

       

      Can these patterns be made configurable?

       

      Regards,

      Shiveeta