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 <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
