Skip to main content
Solved

sql server timestamp read as a buffer datatype


thomastupuivao
Contributor
Forum|alt.badge.img+6

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

View original
Did this help you find an answer to your question?

2 replies

_jacques_
Supporter
Forum|alt.badge.img+13
  • Supporter
  • Best Answer
  • August 14, 2024

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


thomastupuivao
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • August 14, 2024

Thanks, that works!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings