I have a PostgreSQL column with timestamp data stored in a float, seconds since epoc with milliseconds as after the decimal point. For example 1678477483.628172
is Friday, March 10, 2023 7:44:43.628 PM.
This isn't my data, so I have no control over the format.
- In its default state, this column functions normally.
- I am not given the option of casting it to a different type under the "gear" menu
- Setting it to a "Creation Timestamp" semantic type causes the table's summary page to error with:
Output of update-field-options does not match schema: e[0;33m (named [nil nil (named {:binning {:strategy (not (#{:default :bin-width :num-bins} :day-of-week))}} "options")] "Must be a valid instance of one of these clauses: :expression, :field") e[0m
How can I proceed with using this field as the timestamp that it is?