Skip to content

Feature request: fractional timestamps #884

@victorclaessen

Description

@victorclaessen

Steps to reproduce this issue

  1. I have a table with fractional unix timestamps (i.e. 1581342638.720432) in a column defined as DOUBLE, which I use to record events that happen with microsecond-resolution.
  2. I select Grid view options -> This is a UNIX timestamp column
  3. Then I see "2020-02-10 14:50:38", so the fractional part is invisible.

Current behavior

The good thing is that the sorting still seems in order (pun intended), but unfortunately the fraction is invisible.

Expected behavior

I would like to see the fraction of the timestamp as well, if they have a fractional part. (If not, then it's probably neater to hide it.) The example value would read: "2020-02-10 14:50:38.720432".

Possible solution

If you could, please make an option to show the fractional part of the unix timestamp when viewed as a date.

Environment

  • HeidiSQL version:
    10.3.0.5771 (64 bit)

  • Database system and version:
    MariaDB 10.3.22

  • Operating system:
    Windows 10

Metadata

Metadata

Assignees

No one assigned

    Labels

    confirmedIssue verified by project memberenhancementEnhances an existing feature

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions