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,'00');
to_char
-
010102
(1 row)
cmi=> select to_date(to_char(10102,'00'),'MMDDYY');
I'm confused. How do I get the integer 10102 to come in as the date
2002-01-01?
cmi=> select to_date('010102','MMDDYY');
to_date
2002-01-01
(1 row)
cmi=> select to_char(10102,'00');
to_char
-
010102
(1 row)
cmi=> select to_date(to_char(10102,'00'),'MMDDYY'
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,'00');
> to_char
> -
> 010102
> (1 row)
Note the leading space in the returned row. Th
Richard,
> I'm confused. How do I get the integer 10102 to come in as the date
> 2002-01-01?
Hmmm ... isn't this an old post, repeating?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 1: subscribe and unsu
On Mon, 13 Jan 2003, Josh Berkus wrote:
> Richard,
>
> > I'm confused. How do I get the integer 10102 to come in as the date
> > 2002-01-01?
>
> Hmmm ... isn't this an old post, repeating?
Yep, my guess is that he sent it, wasn't on the list so it went for
approval, he joined and resent, and we