Sample Header Ad - 728x90

PostgreSQL: double to bit conversion

0 votes
0 answers
297 views
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.
Asked by Ximik (155 rep)
Jan 25, 2019, 05:02 PM