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

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

deckard posted 1 year 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 1 year 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 1 year ago

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

ansgar posted 1 year ago

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

deckard posted 1 year 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 1 year ago

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

deckard posted 1 year ago

Something like

1448687762.0404

ansgar posted 1 year ago

Ok, next attempt in r5118. Please update.

deckard posted 1 year ago

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

ansgar posted 1 year ago

the value 1473954722.021 still looks strange when converted.

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

deckard posted 1 year ago

Year 40,000 and then some

ansgar posted 12 months ago

r5119 should fix that, hopefully.

deckard posted 12 months ago

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

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