Making sense of expiration shown in UI

I am trying to understand how to reason about what I see in the UI for the expiration field. It looks like it is stored in seconds from what I’ve read. I can perform an insert statement like so:

INSERT INTO test (KEY, VALUE) VALUES (“test”, {“foo”:“bar”}, {“expiration”:2*60});

and I will see the document be removed after two minutes but I don’t understand the number being displayed in the expiration field.

Thanks for any help!

The expiration will be an Epoch/Unix time - so 1670969918 is 2022-12-13T22:18:38Z.

You could SELECT millis_to_str(meta().expiration*1000) FROM ... to get the expiration formatted.


1 Like