"Keith Worthington" <keithw@narrowpathinc.com> writes:
> I have timestamp information in a table. I want to extract the date portion
> for insertion into another table.
You're doing it the very very hard way. Just cast the timestamp value
to date.
regards, tom lane