On Wed, Jan 08, 2003 at 08:49:00 -0600, Richard Rowell <[EMAIL PROTECTED]> 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'). ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster