Skip to main content
Question

How to concatenate a date field (format: mm/dd/yyyy) and a time field (format: hh:mm:ss) to a single field (format: mm/dd/yyyyhh:mm:ss)? They are already transformed by two separate AttributeManager.


image.pngimage

3 replies

david_r
Celebrity
  • June 16, 2023

You can concatenate them as regular strings, e.g. in an AttributeManager:

@Value(my_date_attribute) @Value(my_time_attribute)

 

 


Thank you for answering. they are not strings. the formats are date and time and will be translated to DateTime.


hkingsbury
Celebrity
Forum|alt.badge.img+55
  • Celebrity
  • June 18, 2023
marrysharif wrote:

Thank you for answering. they are not strings. the formats are date and time and will be translated to DateTime.

Thats fine, internally, FME treats datetimes as strings.

In fact datatypes really only exist when data is read/written - oversimplification, some more advanced use cases mean you need to change/specify data types within the process. In your case, datetimes in FME can just be treated as strings


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings