Обсуждение: to_hex leading zeroes

Hi All,

I'm in a bit of a pickle here with the to_hex function not returning leading
zeroes ...
For instance if I:
SELECT to_hex(10);

it returns 'a' not '0a' .

Any ideas on how to overcome this?

TIA,

Pedro Doria Meunier
GSM: +351961720188
Skype: pdoriam

On Sun, Mar 15, 2009 at 6:47 AM, Pedro Doria Meunier
<pdoria@netmadeira.com> wrote:
> Hi All,
>
> I'm in a bit of a pickle here with the to_hex function not returning leading
> zeroes ...
> For instance if I:
> SELECT to_hex(10);
>
> it returns 'a' not '0a' .

Have you looked at lpad()?