DateFormatter

Hi Clive,

 

 

Generally, FME readers translate a datetime value into a character string of "yyyymmddHHMMSS" or "yyyymmddHHMMSS.nnn" format automatically.

 

If you are using the Access reader, connect an Inspector transformer to the reader feature type and check the datetime format with the Data Inspector.

 

 

Takashi

Dont use automatic detection. That automaticaly puts all the zeroes.

 

Your second line ?

 

(%d%/%m%/Y) => (%d/%m/%Y)

Hi Gio,

 

 

How do you disable the automatic detection??

 

 

Regards,

 

 

Clive Swan

 

 

I created a Transformer (ExtractDate).

 

 

Date is exported as a number:

 

ExtractDate

 

20140122000000.000

 

20140122000000.000

 

 

Cannot see where to disable the automatic detection??

 

 

 

 

 

 

 

 

Thanks,

 

 

Clive

"DD/MM/YY" is invalid as the Source Date Format. See the help on the DateFormatter, and specify the source format in correct syntax.

 

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/dateformatter.htm

 

 

Date Attributes: ExtractDate

 

Date Format:     (%d/%m/%Y)

 

Source Format: (%d/%m/%Y)   

 

 

Still exporting Native Oracle format (ExtractDate: 20140122000000.000)

If the source date format is "yyyymmddHHMMSS.xxx", FME can detect datetime automatically. Set "Unknown - Automatic Detection" to the Source Date Format parameter (but if you are using FME 2014 or earlier, you have to remove decimal places ".xxx" beforehand).

or be done with it and just use tcl clock functions ....and take control ;) (i think fme uses that anyway, but tcl functions have a lareger scope)