/* postgres can not */ select cast(cast(1u as date) as datetime); select cast(cast(1u as date) as timestamp); select cast(cast(86400u as datetime) as timestamp); select cast(cast(86400u as datetime) as date); select cast(cast(86400000000ul as timestamp) as date); select cast(cast(86400000000ul as timestamp) as datetime);