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>
