Skip to main content
Question

date loaded incorrectly into oracle Date field, works fine in Windows.

C

Hi I'm loading data from an ESRI .gdb file geodatabase into an Oracle database. When I run the .fmw script from Windows, the date loads fine into an Oracle table 'date' field (e.g. 06/22/2019). But when i run the same .fmw script from Linux FME Desktop, the date in oracle (same oracle db) is messed up (e.g. 02/12/1937). Anyone know how to fix? NOTE: Windows is FME Desktop 2017.1.2.1 Win 32, Linux version = FME 2017.0.1.1 (linux-x64). The .fmw script used was created from the Windows FME Desktop. All other fields seem to load just fine.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • May 28, 2019

Are you using the DateFormatter to force the date field into the required format?

Regularly writing to a database requires a default formatting and that might be different for Windows and Linux.

M
Forum|alt.badge.img+2

@ckintanar Just to expand on @erik_jan 's comment - if you are writing a date or datetime data type, you do need to ensure that the data/time you use to write to Oracle and SQL Server is in the FME standard data time format, not a display format.

Reply


Helpful Members This Week

Community Stats

31,330
Posts
118,851
Replies
38,945
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.