Skip to content

Milliseconds get truncated when being exported to CSV or Delimited Text #2098

@droni1234

Description

@droni1234

Description

The title says it all.

Using Mysql 8 in my case

SELECT current_timestamp(3);

results in

Image

Exporting this gives me this result:

(Export with option: Excel CSV)

"current_timestamp(3)"
"2025-02-20 18:37:42"

(Export with option: Delimited text)

current_timestamp(3)
2025-02-20 18:37:42

I would like to get an export with milliseconds going,
as far as I can traceback this got introduced with this bugfix.
#922

I guess for the meantime I could rollback to an earlier Heidisql version.

Kind Regards

HeidiSQL version

Starting with v11.1

Database server version

Reproduction recipe

Exporting a Datetimes with milliseconds will result in the milliseconds being cut off.

Error/Backtrace

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQL

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions