Alternative solutions would be to just cast to a date, but this requires a code change for existing applications. SELECT timestamp_column::DATE FROM table_name; Another solution could be a UDF, but ...