Thread: to_date() confusion

to_date() confusion

From
Richard Rowell
Date:
I'm confused.  How do I massage the integer 10102 into the date
2002-01-01?

cmi=> select to_date('010102','MMDDYY'); to_date   
------------2002-01-01
(1 row)

cmi=> select to_char(10102,'000000');to_char 
--------- 010102
(1 row)

cmi=> select to_date(to_char(10102,'000000'),'MMDDYY'); to_date   
------------2010-01-10
(1 row)

TIA!

-- 
Richard Rowell <richard@bowmansystems.com>



Re: to_date() confusion

From
Bruno Wolff III
Date:
On Wed, Jan 08, 2003 at 08:49:00 -0600, Richard Rowell <richard@bowmansystems.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').