Hello, I have an Timestamp attribute in UTC time (e.g. 20180311013252.000). I would like to create a new attribute converting the UTC Timestamp to EST/EDT Time. After that both attributes should be transformed to %Y%m%d. In this example the output should be 20180311 for UTC and 20180310 for EDT/EST.
Solved
Timezone
Best answer by takashi
Hi @kat, if you are using FME 2017.1+, you can use the @TimeZoneSet function to convert timezone of a datetime value. e.g.
@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00)You can then format the datetime values with the DateTimeConverter transformer.
The @DateTimeFormat function can also be used instead of the DateTimeConverter transformer.
@DateTimeFormat(@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00),%Y%m%d)See also here to learn more about FME Date/Time functions.
- Best Answer
Hi @kat, if you are using FME 2017.1+, you can use the @TimeZoneSet function to convert timezone of a datetime value. e.g.
@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00)You can then format the datetime values with the DateTimeConverter transformer.
The @DateTimeFormat function can also be used instead of the DateTimeConverter transformer.
@DateTimeFormat(@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00),%Y%m%d)See also here to learn more about FME Date/Time functions.
+45- Evangelist
takashi wrote:
Hi @kat, if you are using FME 2017.1+, you can use the @TimeZoneSet function to convert timezone of a datetime value. e.g.
@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00)You can then format the datetime values with the DateTimeConverter transformer.
The @DateTimeFormat function can also be used instead of the DateTimeConverter transformer.
@DateTimeFormat(@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00),%Y%m%d)See also here to learn more about FME Date/Time functions.
takashi wrote:
Hi @kat, if you are using FME 2017.1+, you can use the @TimeZoneSet function to convert timezone of a datetime value. e.g.
@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00)You can then format the datetime values with the DateTimeConverter transformer.
The @DateTimeFormat function can also be used instead of the DateTimeConverter transformer.
@DateTimeFormat(@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00),%Y%m%d)See also here to learn more about FME Date/Time functions.
Does it consider daylight saving time (-5 in winter and -4 in summer) or it must be changed manually?
takashi wrote:
Hi @kat, if you are using FME 2017.1+, you can use the @TimeZoneSet function to convert timezone of a datetime value. e.g.
@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00)You can then format the datetime values with the DateTimeConverter transformer.
The @DateTimeFormat function can also be used instead of the DateTimeConverter transformer.
@DateTimeFormat(@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00),%Y%m%d)See also here to learn more about FME Date/Time functions.
@TimeZoneSet(@Value(_utc_datetime)+00:00,local)
takashi wrote:
Hi @kat, if you are using FME 2017.1+, you can use the @TimeZoneSet function to convert timezone of a datetime value. e.g.
@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00)You can then format the datetime values with the DateTimeConverter transformer.
The @DateTimeFormat function can also be used instead of the DateTimeConverter transformer.
@DateTimeFormat(@TimeZoneSet(@Value(_utc_datetime)+00:00,-04:00),%Y%m%d)See also here to learn more about FME Date/Time functions.
Is there a way to automatically take into account DST without "local"? I'm creating a model that will run on a server in one time zone but will need to be able to convert the time to PST/PDT automatically.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.