Skip to main content
Question

How to get fractional seconds from gdb date-field

  • July 26, 2016
  • 2 replies
  • 56 views
T

Hi,

i have features in a ESRI FileGeodatabase with date-attributes and i need the fractional second.

I played around with the dateformatter-transformer, but i don't see a date format symbol for fractional seconds.

Any ideas to persuade fme reading the fractional seconds?

    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

    L
    Forum|alt.badge.img

    Hi @thilo

    you can probably handle your date values as a strings. Does FME read something like 201607261115263? If yes, you can use StringReplacer to replace first 12 characters with nothing

    • Text to Match: \\d{12}
    • Replacement Text:
    • Use Regular Expressions: Yes

    or AttributeCreator to get the right three characters from the original values:

    • Attribute Value: @Right(@Value(_date),3)
    T
    • thilo
    • Author
    • July 27, 2016

    Hi @LenaAtSafe,

    replacing the first 12 characters gives only the seconds, but i need also the fractional part (something like this: 2015-03-23 10:23:45.213 => .213 , taken from DateFormatter Online-Help).

    The Documentatiion of DateFormatter says, that the fractional seconds are not supported. I thought that that would be valid only if I use the DateFormatter and not in general.

    A simple test-workspace (copy , duplicate reader on writer, gdb2gdb) shows, that the date-values are rounded to seconds, the fractional part are lost.

    Community Stats

    32,631
    Posts
    123,869
    Replies
    41,014
    Members
    Terms & ConditionsAccessibility 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.