Database Time Conversion


Even though I already read the announcement, I was very freaked out seeing all my unix times in a readable format. Can we add a hover tooltip that says “Translated from Unix XXXXXX”?

i think it should be the other way around

1 Like

Yeah, I like this better. Unix time, hover over it to get the readable time.

Edit:
Screenshot 2024-09-23 at 10.19.42 AM
This, basically. It has a no-select so I can’t actually hover, but just an abbr with the time.

Screenshot 2024-09-23 at 10.04.18 AM
Now I’m getting this on one column


And this on two other ones? Same DB…

Edit: The “Created At” and “Updated At” are apparently auto-created. :person_shrugging:

The Created At and Updated At columns are synthetic columns created by Inventor (just like ID, they aren’t created or managed by you). We’ve always stored this data, it just wasn’t being exposed. You can’t edit/rename/delete them and the values cannot be edited (except for updated at, which changes whenever the row is updated).

The new unix decoder functionality is a separate feature. On columns that you create, if the name contains a qualifying word (unix, time, etc.) and the value appears to be a valid unix timestamp, it will be converted into a human-readable timestamp in your browser’s local time in parenthesis next to the unix value. This only happens client-side on the database viewer. You can see this on the timestamp column that you’ve created.

We could expose the created at/updated at times as unix values in the database viewer if that is something that would be useful.

1 Like