to_date confusion - Mailing list pgsql-sql

From Richard Rowell
Subject to_date confusion
Date
Msg-id 1041911915.2836.1.camel@workstation
Whole thread Raw
Responses Re: to_date confusion
List pgsql-sql
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,'000000');to_char 
--------- 010102
(1 row)

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

TIA!



pgsql-sql by date:

Previous
From: "David Durst"
Date:
Subject: Returning row or rows from function?
Next
From: "Daniel Schuchardt"
Date:
Subject: Re: Inherancing