Re: get date in binary number format - Mailing list pgsql-general

Tom Lane dijo:

> "Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> > I get this when I try the following select:
>
> > testdb=> select "bit"((date_part('doy', now()))::integer);
> > ERROR:  Function 'bit(int4)' does not exist
>
> In CVS tip I get
>
> regression=# select "bit"((date_part('doy', now()))::integer);
>                bit
> ----------------------------------
>  00000000000000000000000100001101
> (1 row)

Is there a way to cast these bitstrings into varchars or something?  I
can't find any.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
Hi! I'm a .signature virus!
cp me into your .signature file to help me spread!