Skip to main content
  • EN

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?

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

Thanks, that works!

Reply


Community Stats

30,162
Posts
114,481
Replies
37,808
Members
Terms & ConditionsCookie settings
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.