Skip to main content
Archived

Make DateTime with offset types coming out of readers consequent

Related products:FME Form
  • October 21, 2020
  • 0 replies
  • 6 views
revesz
Supporter
Forum|alt.badge.img+21

DateTime with offset types are slightly different coming out of different kind of reades. Eg:

  • SharePoint List Reader: '20200902084027+00'
  • SQL Server * Reader datetimeoffset(0) type: '2020-10-21 06:33:30 +00:00'

It would make life much easier if DateTime with offset types would come out of any reader in the same format, eg. FME datetime with offset ('20200902084027+00:00')

They could be directly comparable after convertig to UTC without any other hack.

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.

Community Stats

32,749
Posts
124,193
Replies
41,251
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.