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
Rank
Userlevel 2
Badge +16

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
Badge +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


Community Stats

28,706
Posts
109,468
Replies
36,549
Members
Terms & ConditionsCookie 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.