Extracting DATE from a TIMESTAMP field

[Alex Pilson]

I have an old table that has about 2000 records and hasn't been 
modified. I realized it was missing a create_date. Do anyone know or 
have any slick SQL code to extract out the date from the timestamp 
field and update and insert the date into the create_date field?

Thanks!
-- 
<--------------------------------------------------------------->
     Alex Pilson
     FlagShip Interactive, Inc.
     alex@stripped
     404.642.8225 CELL
<--------------------------------------------------------------->