Skip to main content
Solved

String Date/Time is not recognised.

  • November 13, 2020
  • 2 replies
  • 46 views
C
Forum|alt.badge.img

Greetings,

I am reading in Date/Time items in String format from an ESRI REST API.

 

I have a field uploaded with values (below):

1331249589000

1331249634000

1331249646000

1331249638000

 

FME cannot identify/transform the values??

 

Any suggestions or pointers would be appreciated.

Regards,

Clive

 

 

 

 

Best answer by ebygomm

It's a UNIX timestamp (time in milliseconds since epoch)

If you divide the value by 1000 and use %s as the input format in a DateTimeConverter you will be able to turn it into a more recognisable date

    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.

    2 replies

    ebygomm
    Influencer
    Forum|alt.badge.img+46
    • ebygommInfluencer
    • Influencer
    • Best Answer
    • November 13, 2020

    It's a UNIX timestamp (time in milliseconds since epoch)

    If you divide the value by 1000 and use %s as the input format in a DateTimeConverter you will be able to turn it into a more recognisable date

    C
    Forum|alt.badge.img

    Thanks, much appreciated.

    Community Stats

    32,154
    Posts
    122,047
    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.