# \[IGN-5852\] Fix datetime field formats copied from the Database Query Browser resultsets **URL:** \ **Category:** Ignition\ **Created:** [April 11, 2022, 10:45am UTC](https://forum.inductiveautomation.com/t/ign-5852-fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets/58280 "2022-04-11T10:45:21Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [April 11, 2022, 10:45am UTC](https://forum.inductiveautomation.com/t/ign-5852-fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets/58280/1 "2022-04-11T10:45:21Z")
v8.1.5 A picture tells 1000 words: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/7/b70cc2628581778d87e44757d84b6f7504b94d5c.png) 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: > **[Fix datetime field formats copied from the Database Query Browser resultsets...](https://ideas.inductiveautomation.com/ignition-features-and-ideas/p/fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets)** ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 11, 2022, 12:39pm UTC](https://forum.inductiveautomation.com/t/ign-5852-fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets/58280/2 "2022-04-11T12:39:59Z")
With fractional seconds, too, please. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [April 11, 2022, 12:47pm UTC](https://forum.inductiveautomation.com/t/ign-5852-fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets/58280/3 "2022-04-11T12:47:03Z")
Added into my OP and idea, good suggestion ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [December 21, 2022, 9:29pm UTC](https://forum.inductiveautomation.com/t/ign-5852-fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets/58280/4 "2022-12-21T21:29:08Z")
**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 πŸ™‚ ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [December 21, 2022, 9:30pm UTC](https://forum.inductiveautomation.com/t/ign-5852-fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets/58280/5 "2022-12-21T21:30:20Z")
2nd option for me ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [December 21, 2022, 9:34pm UTC](https://forum.inductiveautomation.com/t/ign-5852-fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets/58280/6 "2022-12-21T21:34:55Z")
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](http://canny.io) does not. Same as before. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [December 21, 2022, 10:02pm UTC](https://forum.inductiveautomation.com/t/ign-5852-fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets/58280/7 "2022-12-21T22:02:26Z")
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 πŸ™‚ ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 10, 2023, 7:53pm UTC](https://forum.inductiveautomation.com/t/ign-5852-fix-datetime-field-formats-copied-from-the-database-query-browser-resultsets/58280/8 "2023-01-10T19:53:20Z")
Ended up in 8.1.25: > [@Nightly 8.1 Changelogs - 2022](https://forum.inductiveautomation.com/t/nightly-8-1-changelogs-2022/54636/186): > > Weekly Changelog: 8.1.25-b20230109 Swing 5852: Change format of date(time) values copied to clipboard from the DB query browser Updated the result table in the DB query browser to copy values to the clipboard in an RFC 2339 compatible local datetime format. In addition, adding shift to the copy keystroke will copy values in a tab-separated format suitable for directly pasting into spreadsheet tools such as MS Excel.