Solved

sql server timestamp read as a buffer datatype

Forum|Forum|1 year ago
August 14, 2024
2 replies
95 views

+7

thomastupuivao
Contributor

I have a set of records that read via SQLExecutor which includes a timestamp field (driver_date). This seems to be stored a “buffer” datatype.

I don’t seem to be able to explode this field using the DateTimeExploder as it can’t autodetect the timestamp value as a date/time value.

I’ve tried including a DateTimeConverter, but get the same result. Is there someway to convert the timestamp from “buffer” datatype to datetime?

Best answer by _jacques_

Hi!

If you just want to change the datatype you could use an AttributeManager and change the datatype to datetime.

However I think you could tweak the input format field in the DateTimeConverter to fit your format: %d/%m/%Y %H:%M:%S.

Best regards,

Jacques

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.