distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

deckard posted 4 months ago in Feature discussion

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

ansgar posted 4 months ago

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.

deckard posted 4 months ago

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

ansgar posted 4 months ago

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

deckard posted 4 months ago

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...

ansgar posted 4 months ago

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

deckard posted 4 months ago

Something like

1448687762.0404

ansgar posted 4 months ago

Ok, next attempt in r5118. Please update.

deckard posted 4 months ago

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

ansgar posted 4 months ago

the value 1473954722.021 still looks strange when converted.

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

deckard posted 4 months ago

Year 40,000 and then some

ansgar posted 4 months ago

r5119 should fix that, hopefully.

deckard posted 4 months ago

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

Please login to leave a reply, or register at first.