Skip to main content
Solved

Date Formater

  • July 3, 2013
  • 3 replies
  • 18 views
I
Forum|alt.badge.img+1
Hi,

 

 

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

 

 

Best answer by takashi

Hi Imran,

 

 

FME interprets 'YYYYmmdd' or 'YYYYmmddHHMMSS' formatted string to a datetime value. I think your issue is same as this article.

 

 

Takashi
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

takashi
Celebrity
  • takashiCelebrity
  • Best Answer
  • July 3, 2013
Hi Imran,

 

 

FME interprets 'YYYYmmdd' or 'YYYYmmddHHMMSS' formatted string to a datetime value. I think your issue is same as this article.

 

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
david_r
Celebrity
  • david_rCelebrity
  • July 4, 2013
Hi,

 

 

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
I
Forum|alt.badge.img+1
  • imran
  • Author
  • July 4, 2013
Thanks Guys

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.