intellij-dynamodb icon indicating copy to clipboard operation
intellij-dynamodb copied to clipboard

DateTime columns

Open dkBrazz opened this issue 7 months ago • 1 comments

Is your feature request related to a problem?

DynamoDB doesn’t have a dedicated datetime data type and it is recommended to use Number fields with the Unix timestamp https://aws.amazon.com/blogs/database/working-with-date-and-timestamp-data-types-in-amazon-dynamodb/

Such timestamps are hard to read, so I need to convert these numbers to dates manually in 3rd party tools

Describe the solution you'd like

  • Make it possible to view numeric values as date-time strings
  • It should be possible to switch between modes with a toggle like "Highlight similar items"
  • Autodetection of timestamp fields shold be enough, see example here - https://github.com/ramustha/unix-timestamp/blob/9e1303e58f04b843fd90568382c5d9f88e7c6f71/src/main/kotlin/com/ramusthastudio/plugin/unixtimestamp/utils/Helper.kt#L38

For json view of the record mentioned unix-timestamp plugin works perfectly

Additional context

No response

dkBrazz avatar Jul 22 '24 15:07 dkBrazz