On Wed, Jan 08, 2003 at 08:49:00 -0600,
Richard Rowell <richard(at)bowmansystems(dot)com> wrote:
> I'm confused. How do I massage the integer 10102 into the date
> 2002-01-01?
>
> cmi=> select to_char(10102,'000000');
> to_char
> ---------
> 010102
> (1 row)
Note the leading space in the returned row. That is probably what is making
the difference. You probably want to use to_char(10102,'FM000000').