Question

Convert Date/Time stored as Double to an ISO Date

  • 7 August 2018
  • 2 replies
  • 3 views
D

Hi all,

For some reason an application is storing a date/time field as 'Double' - ''201805241214'' in this format, but the Date converter function does not recognise this as its a double field type, any help is greatly appreciated,

 

2 replies

ebygomm
Rank
Userlevel 1
Badge +10

Are you providing the source date format? e.g. %Y%m%d%H%M

david_r
Rank
Userlevel 4

Agree with @egomm, you'll have to specify the source format.

The issue is the timestamp is "missing" the seconds part, which is why I suspect FME don't automatically recognize it as a timestamp.

Reply


Community Stats

28,654
Posts
109,290
Replies
36,528
Members
Terms & ConditionsCookie settings
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.