copying data from partition and converting

[BeefStu]

For those of you who are intersted here is the solution. Also in the where
clause you can use from paritition (partition_name)

Set's create_date to 2011-05-28

INSERT INTO XXX.YYY
SELECT to_date( '2011-05-28' || to_char( create_date,'HH24:MI SS'), 'YYYY-MM-DD HH24:MI SS' ),
col1, col2, col3, col4 FROM
XXX.YYY where create_date >= TO_DATE ( '2011/02/17', 'yyyy/mm/dd') AND
create_date < TO_DATE ( '2011/02/18', 'yyyy/mm/dd');