Ability to convert float data fields to from unix_datetime to normal date

Hi,

we have an application that writes unix timestapms with decimal separator for extra-detailed timestamps. For normal integer fields HeidiSQL has this amazing feature to activate a conversion from unix_timestamp to date on browsing data.

However the menu entry is not available when the data field type is DOUBLE.

It should be easy to make this available - can you please consider it?

Thank you for a great tooL!

Best regards

Carsten

Yes, that shouldn't be a big deal. Only I'm pretty sure I cannot get the microseconds into the simulated date/time field. I guess that's not a problem, as that feature is some icing on the cake anyway.

I don't care for the microseconds ;). So that would be really great!

Done in r5117. Please report back if it works for you.

Thank you!

Unfortunately it does not convert properly. My original value is a field type DOUBLE. On conversion I get 1970-01-01 dates.

Thank you for having another look...

Works here. At least with "1.0" values :) Sample value which does not work for you?

Something like

1448687762.0404

Ok, next attempt in r5118. Please update.

Looks better. Most numbers are properly converted now but the value 1473954722.021 still looks strange when converted.

the value 1473954722.021 still looks strange when converted.

I cannot test right now, however, what do you mean by "strange"?

Year 40,000 and then some

r5119 should fix that, hopefully.

It now works properly. Thank you very much for your effort!