I have a date in 2010:08:11:13:50:16 format, I want to write this format in oracle.
I've tried it using a date formater transformer but it didn't worked then I split the record and reconcateneted it in the native SQL format of DD-MM-YYYY but it also failed.
Can anybody please help me in this.
IMRAN
FME interprets 'YYYYmmdd' or 'YYYYmmddHHMMSS' formatted string to a datetime value. I think your issue is same as this article.
Takashi
the DateFormatter was recently given a needed overhaul in FME2013 SP2, where it should now be possible to accomplish this.
If you have a previous version of FME, consider the DateConverter custom transformer from the FME Store. It is a lot more robust than the ancient DateFormatter.
David