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
Yeah, I like this better. Unix time, hover over it to get the readable time.
Edit:
This, basically. It has a no-select so I can’t actually hover, but just an abbr with the time.
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.
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.