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
    No fields configured for issues without a type.

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions