[IGN-5852] Fix datetime field formats copied from the Database Query Browser resultsets

Ignition
1

v8.1.5

A picture tells 1000 words:

image
image1005×292 93.9 KB

The date format copied into clipboard when copying a datetime from the database query browser simply isn’t useable. Can this please be copied as ISO 8601 datetime format?
Edit: with fractional seconds as well (from Phil)

Vote here:

3 Likes
2

With fractional seconds, too, please.

1 Like
3

Added into my OP and idea, good suggestion

4

Actual ISO-8601?

Including the timezone, specifically?
As in:
yyyy-MM-ddTHH:mm:ss.SSSZ

Or would you prefer a concession to human readability and just an orderable, all-numeric 'local' datetime?
yyyy-MM-dd HH:mm:ss.SSS

I can see arguments both ways, so I figured I'd defer to some actual users :slight_smile:

5

2nd option for me

1 Like
6

FWIW, after a some success some months ago, I am again unable to log into the ideas site. Neither in Firefox nor Chromium. Login appears to succeed (once), but redirects back to the ideas site without credentials. Further attempts simply redirect back. IA's SSO thinks I'm signed in, but canny.io does not. Same as before.

7

Good enough for me.
As a bonus, I'm adding ctrl + shift + C to copy to clipboard as TSV, so you can directly paste into Excel :slight_smile:

3 Likes
8

Ended up in 8.1.25:

1 Like