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

New feature: Display UNIX timestamps as date/time values

User, date Message
Written by ansgar
1 year ago
Category: News
4973 posts since Fri, 07 Apr 06
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.

Written by r569594043
1 year ago
4 posts since Sat, 08 Jun 13
great!!!happy
Written by quelbs
1 year ago
1 posts since Sat, 08 Jun 13
Thank you for your quick implementation of this idea.
Michael
Written by harry0815
12 months ago
2 posts since Thu, 05 Sep 13
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.
Written by harry0815
12 months ago
2 posts since Thu, 05 Sep 13
Sorry, I meant milliseconds. But there might be also folks outside who store the timestamp in microseconds ;)
Written by justpusherMoney, Euro
11 months ago
28 posts since Wed, 31 Mar 10
Thank you very much! Very needed feature!
Written by maXus
10 months ago
5 posts since Wed, 30 Oct 13
Great, but is it possible to do the same with IP's? (INET_NTOA and INET_ATON)

Gruß Marcus
Written by justpusherMoney, Euro
10 months ago
28 posts since Wed, 31 Mar 10
+1 for inet_ntoa.
Written by ansgar
10 months ago
4973 posts since Fri, 07 Apr 06
Well, not yetsmileDifferent feature. File a request in the tracker?
Written by justpusherMoney, Euro
10 months ago
28 posts since Wed, 31 Mar 10
I've created issue 3402 regarding IPs similar to existing issue 3215 regarding unix timestamps.
Written by maXus
10 months ago
5 posts since Wed, 30 Oct 13
Top, thanks!
Written by maXus
9 months ago
5 posts since Wed, 30 Oct 13
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.
Written by ansgar
9 months ago
4973 posts since Fri, 07 Apr 06
Copying UNIX timestamp as integers was fixed some time ago. You should update your HeidiSQL to the latest build.
Written by maXus
9 months ago
5 posts since Wed, 30 Oct 13
Ah ok, I wait for the stable version. Thank you.
Written by ansgar
9 months ago
4973 posts since Fri, 07 Apr 06
... 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.