convert timestamp to date

[vanidamodaram]

can any one help me for the following problem
i have a timestamp database column in a table which is having some timestamp values and some are not there. so now i want to delete the timestamp values which are having other than date and the same time i want to alter the column into date can i.

[debasisdas]

Since you have posted a question in the article section it is being moved to oracle Forum.

MODERATOR

[debasisdas]

Do you want to remove only the time part of the timestamp field.

in that case , try the following

update table set field_name = trunc(field_name);

alter table tabele_name modify field_name date;