Field Type - Time only

Hi ​@adnanyazdani ,

Supported data types are depending on data format. If "time" type doesn't appear in the drop down list, you can think that the format doesn't support the type.

​@takashi 

Thanks for the reply

Actually i received the information of time in text field and our schema is time only..

Here comes the challenge because i have very huge time.

Any Suggestion

Hi ​@adnanyazdani That depends on the file format of the writer you are using. 

I am just guessing here but it looks to me like you are trying to write in an ESRI File Geodatabase? 

Are you using the File GDB Open API writer? Then I do not think there is an option as time only is a newer field type for ESRI and GDBs

Below is a pic from a File Geodatabase Writer (not the Open API version) so time is an option. Again this all depends on the type of file you are trying to write. Hope this helps.
 

​@adnanyazdani 

If the destination format doesn't support "time" type, it's a general alternative to treat a time value as a text. Is there any problem if time values are stored in a text type field of the destination dataset?

yes , you were right

I was using ESRI Open API because I was getting an error

 

How can i resolve this error when i use Esri Geodatabase (File Geodb) transformer

Thanks Again

adnanyazdani wrote:

yes , you were right

I was using ESRI Open API because I was getting an error

 

How can i resolve this error when i use Esri Geodatabase (File Geodb) transformer

Thanks Again

Well then…. Do you have access to the full File Geodatabase Writer in FME? You will have to have an active ESRI License to use this and that is a licensing thing not a software capability thing.

If you are forced to use the ESRI Open API then I….that might be a problem. I would go with ​@takashi ‘s suggestion of treating the data as text might work for you. You may have to play around with the EXACT format that ESRI is expecting in a time field though. Hope that helps! Good luck!
Convert string or numeric time values into date format—ArcGIS Pro | Documentation
Supported field formats—ArcGIS Pro | Documentation 
Hope that helps!