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

New feature: Display UNIX timestamps as date/time values

ansgar posted 1 year ago in News
One of the best new ideas in my eyes came from quelbs. Using an integer column for storing UNIX timestamp values is a wide spread approach in the world of web development. For example in a Typo3 database, all date/time handling is done with UNIX timestamps. Unfortunately, for MySQL this is of course a normal integer value, with no meaning of being a date/time value.

Now, HeidiSQL allows the user to explicitly set a column to "This is a UNIX timestamp" via right click menu. Once activated, integers are internally converted to and displayed as human readable date/time values. Editing such values also uses the inplace editor for date values.

r569594043 posted 1 year ago
great!!!happy
quelbs posted 1 year ago
Thank you for your quick implementation of this idea.
Michael
harry0815 posted 1 year ago
For all of us fuzzing around with Unix timestamps this is a really great addition, saves a lot of time and confusions. Thanks a lot for this!

However... ;)
For some of us the second precision is not good enough, so we store the timestamp in millisecond precision. Unfortunately this is not recognized at the moment.

Example which you can check e.g. with http://www.epochconverter.com/ :
o 1378391224 is the simple UNIX timestamp which resolves to 05.09.2013 14:27:04
o 1378391224123 adds milliseconds which resolves to 05.09.2013 14:24:04.123

Would it be possible to extend this great feature to also recognize timestamps in microseconds? Maybe this can be auto-detected (larger numbers) or added a sub-menu option?

If this makes sense, I would be happy to propose an improvement and write a request similar to #3215.
harry0815 posted 1 year ago
Sorry, I meant milliseconds. But there might be also folks outside who store the timestamp in microseconds ;)

justpusher posted 1 year ago
Thank you very much! Very needed feature!
maXus posted 1 year ago
Great, but is it possible to do the same with IP's? (INET_NTOA and INET_ATON)

Gruß Marcus
justpusher posted 1 year ago
+1 for inet_ntoa.
ansgar posted 1 year ago
Well, not yetsmileDifferent feature. File a request in the tracker?
justpusher posted 1 year ago
I've created issue 3402 regarding IPs similar to existing issue 3215 regarding unix timestamps.

maXus posted 1 year ago
Top, thanks!
maXus posted 12 months ago
is there a solution to copy the timestamps as timestamp, not as value time? currently is use timestamp in a row, but i can copy only the full date/time, not the real timestamp.
ansgar posted 12 months ago
Copying UNIX timestamp as integers was fixed some time ago. You should update your HeidiSQL to the latest build.
maXus posted 12 months ago
Ah ok, I wait for the stable version. Thank you.
ansgar posted 12 months ago
... and I should release one in December. Many bugs fixed already, and many users don't get these fixes. According to my download statistics, the major part of HeidiSQL users only updates when major or minor releases are out.

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