Consider the following table definition, where datetime_record is a UDT:
CREATE TABLE support (id INTEGER ,information datetime_record );
Assuming an appropriate cast definition exists for the datetime_record UDT, the following statement converts the values in the information column to DATE:
SELECT id, CAST (information AS DATE) FROM support;