I am looking to copy data from one partition to another for testing purposes.

My table is partitioned on create_date so I would like convert the old
create_date values (2011-05-20) to a new values (2011-05-21) so it
goes into another parition. In addition, I want is there any easy way to
convert null values to a default value.

Can this be done via a SQL statement? Is so can somebody provide and example or point me to the correct place in the documentation.

Thanks