I need bit(64) representation of current epoch (the operations I need should be much easier in bits), so
SELECT extract('epoch' from CURRENT_TIMESTAMP)::bit(64)
But this gives me
ERROR: cannot cast type double precision to bit
What am I doing wrong here?
UPD: In fact, I understood I should do it the other way, but the ERROR itself is still very strange for me.
