[SQL] to_date confusion

2003-01-13 Thread Richard Rowell
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');

Re: [SQL] to_date confusion

2003-01-13 Thread Josh Berkus
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

Re: [SQL] to_date confusion

2003-01-13 Thread Stephan Szabo
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're now

[SQL] to_date() confusion

2003-01-08 Thread Richard Rowell
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');

Re: [SQL] to_date() confusion

2003-01-08 Thread Bruno Wolff III
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. That is