AnsweredAssumed Answered

Showing Time from Oracle Date Using ESS?

Question asked by eric on Dec 14, 2016
Latest reply on Dec 15, 2016 by nicolai

Oracle date fields often have a time component, making them the equivalent of a FileMaker timestamp.

A Comparison of Oracle's DATE and TIMESTAMP Datatypes — DatabaseJournal.com

However, FileMaker's ESS (External SQL Source) shows Oracle dates as FileMaker date types, which fails to reveal the time component that is present on Oracle.

Without altering the Oracle field types, is there a way to get FileMaker's ESS to display the time component of an Oracle date field?

Outcomes