1# There are two ways to change data type. By using CAST or ::
2# Eg. CAST (column_name AS target_type) OR column_name::target_type
3
4SELECT
5 CAST (date_occurred AS DATE)
6 CAST (total_amount AS INTEGER)
7 CAST (duration AS INTERVAL)
8# OR
9 date_occurred::DATE
10 total_amount::INTEGER
11 duration::INTERVAL